Query problem

  • Thread starter Thread starter Poppy
  • Start date Start date
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
 
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
 
Back
Top