asked
How to remove records from one table based on records present in another table?
Suppose we have two tables T1 and T2 as described below: T1:- Col 1 Col2 Valid 1 a 120 2 b 232 1 b 435 3 a 123 2 c 532 T2:- Col 1 Col2 Invalid 1 a 1133 2 b 2321 2 a 4234 Now what can be the simplest query to remove all the records from T1 which are also present in T2 having the same values of both the columns Col1 and Col2. For example 1-a combination is present in T2 so it should be removed from T1 whereas 1-b should not be removed from T1.
Below code will help you DELETE T1 FROM T1 INNER JOIN T2 ON T1.Col1 = T2.Col1 AND T1.Col2 = T2.Col2
18 People are following this question.
