I have a requirment where i need to delete data from TAbleA depending on a condition in TableB
The condition is
TableB.Id should not exist in TableA
TableA and TableB have column 'Id'
I am trying to write this sql but having problems
delete top (50) from TAbleA TA where TableB.id NOT IN (select id from TableA)
any help wil be appreciated