Table-Query Relationship 2

[dmears1]

Access noob here with a question. I need to compare records in a Table with the results of a query. In a nutshell here's what I need to happen:

Table contains master list of records. Say there are 100 records in this table. The query returns 25 records. I need a query that will compare both and return the remaining records in the table not contained in the query. Does that make sense?

In noobish SQL:

Select from TableA join QueryB
Where TableA.ID != QueryB.ID

After googling I found mention of a "theta join" that looks like what I need to do, but I can't find instructions on accomplishing this.

Any help would be greatly appreciated.

http://www.Morter.com

 

[PHV]

SELECT A.*
FROM TableA As A LEFT JOIN QueryB As B ON A.ID = B.ID
WHERE B.ID Is Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dmears1]

Thanks PHV, that was perfect.

http://www.Morter.com

 

[dmears1]

One more question: I'm guessing that the key part of the query is the "WHERE B.ID Is Null" otherwise the query would return all records contained in TableA, correct?
If so, why is that?

http://www.Morter.com

 

[PHV]

why is that
Because it's a LEFT outer join.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

for more information check out Understanding SQL Joins

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[dmears1]

Thanks Lespaul fo the link, easy-to-understand explanation.

http://www.Morter.com