Using the relationship table

Create Queries in SQL Statements

1. Join Dealership and Employee tables and display all columns. Include dealerships with no employees and employees with no dealerships. Your query needs to return data that is the result of a FULL OUTER JOIN, but note that there is no such syntax in Access, so you need to come up with an Access SQL work around.

Relationships Invoice Purchaser Employee Vehicle Customer Dealership 9 dstate Relationship