How to differenciate two tables
- by Nemat
Hi friends....
I have two tables.I want to get all records from one table that are different from the records in second table.
For eg.
if we have four records in first table like A,B,C,D and three records in second table thats A,B,C then the answer of query should be D.
I have tried "EXCEPT" operator but it doesnt work fine.Kindly help me in writing correct query for the given problem.
Any help is appreciated....
Thanks in Advance
Nemat