Hi friends need Delete Query
Delete from StoreGroupMember Where d in (select * from StoreGroupMember a ,store where a.Store_id=Store.id and store.StoreNumber=9833) d
I need to Delete the Records which Satisfies the Below condition,
select * from Table1 a ,Table2 where a.Store_id=Tables2.id and Table2.StoreNumber='AAAA'
And i need to delete the records from Table 1 only,
Delete from Table1 Where d in (select * from Table1 a ,Table2 where a.Store_id=Tables2.id and Table2.StoreNumber='AAAA') d
Please help me out...