Compare two tables for matching criteria

M

Mackay 1979

Is it possible to report out any examples where a ID exists in Table1 but
doesn't have an entry in Table2?

My first table (Table1) has a list of entries of system changes, my second
table contains information on testing that will occur for each change.

I want to know if there are any examples where no testing has been defined
(e.g. no entry in Table2).

Appreciate your help. Thanks, al. ([email protected])
 
B

Brendan Reynolds

SELECT * FROM Table1 WHERE Table1.ID NOT IN (SELECT Table2.ID FROM Table2);

.... or ...

SELECT Table1.*
FROM Table1 LEFT JOIN Table2 ON Table1.ID = Table2.ID
WHERE (((Table2.ID) Is Null));
 
M

Marshall Barton

Mackay said:
Is it possible to report out any examples where a ID exists in Table1 but
doesn't have an entry in Table2?

My first table (Table1) has a list of entries of system changes, my second
table contains information on testing that will occur for each change.

I want to know if there are any examples where no testing has been defined
(e.g. no entry in Table2).
Click to expand...


Use the query wizard to create an unmatched query.
 
J

John Vinson

Is it possible to report out any examples where a ID exists in Table1 but
doesn't have an entry in Table2?
Click to expand...

Certainly. Use the "Unmatched Query Wizard" in the New Query option.

John W. Vinson[MVP]
 
Top