Query Joins

[dtoney]

When capturing data from another database owned by another group, I need all
of the data for 120 days from tableA and all of the data that matches by
keyID from tableB. However, when I try to pull in the data from a single make
Table query, I only get data from TableA that has data in TableB. Is this
because I do not have the proper join?

 

[Jerry Whittle]

Yes. You probably have an inner join which requires data in both tables
before it will return a record.

In query design view, double click on the join line between the two tables
until you see a dialog box. Try the second option which is a left join.

 

[Marshall Barton]

When capturing data from another database owned by another group, I need all
of the data for 120 days from tableA and all of the data that matches by
keyID from tableB. However, when I try to pull in the data from a single make
Table query, I only get data from TableA that has data in TableB. Is this
because I do not have the proper join?

I think so. In the query designer right click on the join
line and select the option for all records from tableA and
any matching record form tableB