Removing common fields

A

adrian

Hi,

I have a Query A which has fields F1, F2 and F3. I have another query,
Query B which has field F3. How do I create a query, Query C such that it is
the result Query A - Query B i.e. Query C has only the results of Query A
with fields F1 and F2 only ?
Thanks.
 
B

Baz

adrian said:
Hi,

I have a Query A which has fields F1, F2 and F3. I have another query,
Query B which has field F3. How do I create a query, Query C such that it is
the result Query A - Query B i.e. Query C has only the results of Query A
with fields F1 and F2 only ?
Thanks.
Click to expand...

Unless I'm missing something here, Query B is irrelevant. Surely Query C
would simply be:

SELECT F1, F2 FROM [Query A]
 
C

Chaim

One thing you should know, which is implied by Baz's response, is that a
Query can be used like a table.
 
J

John Spencer (MVP)

If you mean you want the records in query A that have no corresponding value in
QueryB field F3 then

SELECT QueryA.F1, QueryA.F2
FROM QueryA LEFT JOIN QueryB
 
Top