Viewing 2 posts - 1 through 3 (of 3 total)
I believe Louis Hillebrand's query deletes all record. Need to add ConsumerID=99 in condition.
October 9, 2013 at 9:44 am
#1657211
Using Co-related query:
DELETE FROM tablea
WHERE ConsumerID IN
(SELECT ConsumerID FROM Tableb b WHERE tablea.ConsumerID=b.ConsumerID and b.DeleteFlag=1)
AND ConsumerID=99
October 9, 2013 at 4:18 am
#1657060