Unmatched Query

[PeteJM]

Hi,

I can create unmatch quiries using tables but i don't seem to be able to do it using quiries.

I want to look at the values in on Query1 and compare it with Query2 and return the results that don't have a match.

Is there somthing different i need to do when using quiries instead of tables.

Regards

Pete

 

[RV]

Pete,

you can compare queries for unmatched records the same way you can compare tables.
Create a new query and use the "Find unmatched query Wizard".
Otherwise, provide us with a proper problem description, your info is rather brief...

RV

 

[raskew]

Hi -

Here's an example of query-SQL using two identically structured tables.
Change the table/fields to fit your situation:

SELECT  DISTINCT
    ytest1.Name1
  , ytest1.Name2
FROM
   ytest1 
LEFT JOIN
   ytest2 
ON
   (ytest1.Name1 = ytest2.Name1) 
AND
   (ytest1.Name2 = ytest2.Name2)
WHERE
   (((ytest2.Name1) Is Null) 
AND
   ((ytest2.Name2) Is Null));

HTH - Bob