How to differentiate two tables
Posted
by Nemat
on Stack Overflow
See other posts from Stack Overflow
or by Nemat
Published on 2010-05-12T13:23:21Z
Indexed on
2010/05/12
15:04 UTC
Read the original article
Hit count: 140
I have two tables and I want to get all records from one table that are different from the records in second table.
Eg.: if we have four records in the first table like A,B,C,D and three records in the second table thats A,B,C then the answer of query should be D.
I have tried "EXCEPT" operator but it doesn't work fine. Kindly help me in writing correct query for the given problem.
© Stack Overflow or respective owner