Home Forums SQL Server 2014 Development - SQL Server 2014 Delete Row from one table if other table with multiple rows meet the condition RE: Delete Row from one table if other table with multiple rows meet the condition
T.Ashish
SSCarpal Tunnel
Points: 4248
More actions
October 9, 2013 at 3:11 am
#1657041
DELETE A FROM A INNER JOIN B ON A.consumerID = B.consumerID WHERE A.consumerID = 99 AND B.deleteflag = 1