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: 143

Filed under:
|
|

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

Related posts about android

Related posts about sqlite