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 3:10 am

    #1657040

    CREATE TABLE [A]

    (consumerID INT, XXXX INT, AAAAA INT, BBBB INT)

    CREATE TABLE

    (consumerID INT, Product INT, DeleteFlag BIT, DDDD INT)

    INSERT INTO A VALUES (99,1,2,3)

    INSERT INTO A VALUES (100,2,3,4)

    INSERT INTO B VALUES (99,1,1,4)

    INSERT INTO B VALUES (99,2,1,5)

    INSERT INTO B VALUES (99,1,0,6)

    INSERT INTO B VALUES (99,5,1,3)