Show ontly the information that's not in table A

L

Laputa

Hello, I need some help with a query...
I have two tables table1 and table2 they are linked by table1.Upas_i
---> table2.Upas_id.
In table2 there are only few Upas_id, while in table1 there are al
Upas_id. And I want the query to give me all the information that's i
table1, except the one whose Upas_id is in table 2. I just want to ge
the all information from table1 except table1.Upas_id=table2.Upas_id
I expect to do that with exsist not exsists function...
can someone help
 
R

Rick Brandt

Laputa said:
Hello, I need some help with a query...
I have two tables table1 and table2 they are linked by table1.Upas_id
---> table2.Upas_id.
In table2 there are only few Upas_id, while in table1 there are all
Upas_id. And I want the query to give me all the information that's in
table1, except the one whose Upas_id is in table 2. I just want to get
the all information from table1 except table1.Upas_id=table2.Upas_id
I expect to do that with exsist not exsists function...
can someone help?
Click to expand...

SELECT table1.*
FROM table1 Left Outer Join table2
on table1.Upas_id = table2.Upas_id
WHERE tabel2.Upas_id Is Null

The query wizard has an option that will build this query for you (unmatched).
 
Top