I have 2 tables named T1 and T2.
Both of them have 3 identical columns named C1, C2 and C3. All 3 columns have created a composite key.
I want to delete data from the 2 nd tables which data are not in 1st table without using any cursor.
For your better understanding I am providing some sample values.
The data in the columns are given bellow.
Table: T1 C1 C2 C3
------------------
1 A X
1 B Y
2 C Z
1 A Z
Table: T2 C1 C2 C3
-----------------
1 A X
1 B Y
2 C Z
1 A Z
1 B X
Now I want to delete data(rows) from the T2 where the C1 value is 1.
and all the 3 columns values are not same.
Like in the above example the last row in the T2 table
there C1 values is 1. and in Table1 there is no row with that data value.
So here my target row to delete from Table T2 is that row. This may be more than 1 row also.
Please help me.