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

  • October 9, 2013 at 4:18 am

    #1657060

    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