Retrieve all data even those with null field...

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

Guest

Hello All,

I have a query that returns data from one table. I then take the results of
that query and query one of the fields against another table. Sometimes, the
field in the first query can be null, in which case I still want the record
to appear but with a null value for that field. The following is an example:

City State Zip County
Upland CA 91784 San Bernardino
Tempe AZ

The first three fields are from the first query. The County field is
returned as a result of the second query. I would like BOTH of these records
to be returned after the second query. The problem I am having is that a
null in the zip field as a result of the first query results in the record
not being shown at all in the results of the final query.

I hope this makes sense. Can anyone help? I would appreciate any assistance.

Thanks,

Trevor
 
Hard to say, but as a guess you need to change the query from an INNER JOIN to a
LEFT Join or a RIGHT Join.

If you have built the query in the query grid, then you should double-click on
the join line and then select the option that shows all the records in the query
and only the matches in the table.
 
Back
Top