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 7, 2013 at 12:39 pm

    #1656482

    Hi i do not want to delete consumerID 100 as deleteflag is 0 for one product

    and moreover this is not a home work , but i am trying to do it in a simple way for the below query

    DELETE Table A

    FROM TableA a

    INNER JOIN TableB b ON b.ConsumerID = a.ConsumerID

    WHERE a.ConsumerID IN

    (

    SELECT ConsumerID FROM TableB WHERE DeleteFlag= 1 AND ConsumerID NOT IN (SELECT Consumer_ID FROM Visitor_By_Brand WHERE Delete_Flag =0 )

    )