Data Filtering
Posted: Thu Jun 07, 2007 10:08 pm
Hi,
In one table i have a data like this
Table1
code1 code2 code3
12 1 1
12 1 2
12 2 1
And in an another table i have a data like this
Table2
code1 code2 code3
12 1 1
Code1 is common in both table
But i need only those data which are not in Table2.
ie.
code1 code2 code3
12 1 2
12 2 1
How can write the query to get those data.
Thanks
In one table i have a data like this
Table1
code1 code2 code3
12 1 1
12 1 2
12 2 1
And in an another table i have a data like this
Table2
code1 code2 code3
12 1 1
Code1 is common in both table
But i need only those data which are not in Table2.
ie.
code1 code2 code3
12 1 2
12 2 1
How can write the query to get those data.
Thanks