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