I need to delete all the rows in the multiple rows where it's the same UserId. Please look at my Delete command below:
DELETE FROM tableA
FROM tableA INNER JOIN
tableB ON tableA.UserId = tableB.UserId INNER JOIN
tableC ON tableA.UserId = tableC.UserId INNER JOIN
tableD ON tableA.UserId = tableD.UserId
WHERE (tableA.UserId = @UserId) AND (tableB.UserId = @UserId) AND (tableC.UserId = @UserId) AND (tableD.UserId = @UserId)
What is happening from the above query is only the rows from tableA is getting deleted.
Please help me on this.
Last edited by laxatcg1; January 5th, 2010 at 03:59 AM.
Reason: Change in content