Query problem

P

Poppy

I have 2 tables, each which contain usernames and id's.

I need to extract all users from tableA which do not appear in tableB but
cant figure out the syntax of the query.

Any Ideas ?

Thanks in advance
 
M

Marshall Barton

Poppy said:
I have 2 tables, each which contain usernames and id's.

I need to extract all users from tableA which do not appear in tableB but
cant figure out the syntax of the query.
Click to expand...


SELECT tableA.*
FROM tableA LEFT JOIN tableB
ON tableA.user = tableB.user
WHERE tableB.user Is Null
 
Top