Counting absent id/records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that counts the records in a table for each id. e.g. id 1 is
in the table 6 times so the query gives a count of 6....
I link it to the main table where all the id's are at. Is there a way to
tell what queries were not used?

Mike J
 
Certainly. You need a left join.

SELECT Table1.ID, Table2.ID
FROM Table1] LEFT JOIN Table2 ON Table1].ID = Table2.ID
WHERE Table2.ID Is Null;

In the QBE grid double click on the line that links the two tables. Select
either the first or second option and see what happens.
 
Back
Top