multi-table query

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

I am attempting to do a query using fields from two tables. Table 1
contains basic customer information and Table 2 contains information if the
customer is working with a vendor (not all customers have an entry in this
table as not all customers are working with a vendor). The tables are
joined by a common Customer ID.

When I use fields from Table 1 only it works fine; however, when I bring
fields from Table 2, it only returns customers that are working with a
vendor and have an entry in Table 2. Is there a way to view customers that
are both using and not using a vendor while still including fields from
Table 2 in my query?

Thank you in advance for any assistance.

LB
 
Yes, right-click the 'join' that is drawn between the two tables and change
it to...

Include ALL records from table Customers and only those records from Vendors
where...
 
Right click on the line that joins the 2 tables in the query and select join
properties. Select the option show all from table 1 and only those from table
2 where join fields are equal
 
Back
Top