You need to make name tags for each person coming to the model car convention. You should also make sure that every company in your Customers table is represented, but also include the first name from the CustomerContacts table if there are matches.

First, you must create a query to select the first name from the CustomerContacts table and the company name from the Customers table. Use the appropriate join type to pick up all records from Customers and any matches from CustomerContacts. Save this query as LabelQuery.
Hint: there are two customers in the Customers table who don’t have associated entries in the CustomerContacts table: Hobby Box and Frank’s Fun Factory. If you don’t change the default join type when creating this query, those records won’t be included when you make the labels.

Next, generate labels (label type of your choice) from the query you just created that show the first name on line one and the company name on line two. Sort by company name.

Hint: Highlight your query in the navigation pane down then left then go to the Reports group on the Create tab and choose Labels.

SELECT tblCustomerContacts.FirstName, tblCustomers.CompanyName
FROM tblCustomerContacts 
INNER JOIN tblCustomers
 ON tblCustomerContacts.CompanyName=tblCustomers.CompanyName
ORDER BY tblCustomers.CompanyName;

im expecting not to get the annoying enter parameter value prompt and there are two customers in the Customers table who don’t have associated entries in the CustomerContacts table: Hobby Box and Frank’s Fun Factory. If you don’t change the default join type when creating this query, those records won’t be included when you make the labels