Sep 18, 2003 #1 Tock MIS Sep 18, 2003 1 0 0 US I am trying to delete rows from table one when values equal values in table two. I cannot find an example. Can someone help?
I am trying to delete rows from table one when values equal values in table two. I cannot find an example. Can someone help?
Sep 18, 2003 #2 pankajv Programmer Jan 30, 2002 178 0 0 IN DELETE TAB1 FROM TAB1 T1 INNER JOIN TAB2 T2 ON T1.Value = T2.Value Thanks, Pankaj Upvote 0 Downvote
Sep 19, 2003 #3 iker3000 Programmer Feb 20, 2002 56 0 0 HU DELETE FROM TAB1 WHERE TAB1.Value IN (SELECT DISTINCT TAB2.Value FROM TAB2) (Distinct is only good if Tab2 contains many rows but the given column is not very diversified) Iker Upvote 0 Downvote
DELETE FROM TAB1 WHERE TAB1.Value IN (SELECT DISTINCT TAB2.Value FROM TAB2) (Distinct is only good if Tab2 contains many rows but the given column is not very diversified) Iker