[Resolved] Pseudo left join

[terfle]

I need to compare the results of two queries from the same table and display the results that are NOT the same in the second query.

i.e.

SELECT * FROM tableA WHERE userID = 1;

Results In

A
B
C

SELECT * FROM tableA WHERE userID = 2;

Results In

C
D
E

I would want D & E to be printed. Any idea on this query? This query is from the same table, not two different tables.

[ihcra]

SELECT * FROM tableA
WHERE (userID = 1 OR userID = 2)
AND NOT (userID = 1 AND userID = 2)
;

[Ravenous]

classic set difference..

SELECT column_name(, column_name, ...) FROM table_name WHERE some_col NOT IN (SELECT col_name FROM table_name WHERE some_clause);

The key is NOT IN.

Play around with it and you'll be good to go.