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
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