Retrive all unmatched records

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi,

We are developing a Property inspection query. We would
like to retrive all Property with Inspection date is NULL.

Property and Inspection are two different tables. I know
how to extract all information about property that has
been inspected (INNER JOIN between the two tables).
However, how can we get those property information with no
entry in the Inspection Table ?

Thanks
 
You need a Left Join, and a criterion of Is Null for a field from the
Inspection table.

In the QBE window, right-click on the join between the two tables, and
select the "All records from Properties and only those records from
Inspections where the joined fields are equal". Include a field from the
Inspection table (InspectionDate), and enter Is Null in the Criteria line
for that field.

HTH,

Rob
 
Back
Top