Query on multiple tables - one with no data

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

Guest

I have created a query to get data from three different tables, all using the
same primary key. It works fine if all three tables have data attached to
that key, but if at least one of them doesn't then the query comes back
completely empty. What can I do so that it will display the fields from the
tables that it can retrieve and blanks for the other? - Newbie
 
Change the JOIN between the tables. Right now you have it set to "only
include rows where the joined fields from both tables are equal". You need
to change it to "display ALL records from table a and only those records
from table b where the joined fields are equal".

Where table A is your table that includes all the records and table b is the
table that may or may not include matches.

Do this for both joins.
 
Back
Top