[Solved] Create Queries in SQL Statements that work in Microsoft Access

5/5 – (1 vote)

Create Queries in SQL Statements that work in Microsoft Access

A) Join Dealership and Employee tables and display all columns. You must use INNER JOIN and ON syntax for this query.

B) Join Dealership and Employee tables and display all columns. Include dealerships with no employees. You must use LEFT JOIN and ON syntax for this query.

C) Join Dealership and Employee tables and display all columns. Include employees with no dealerships. You must use RIGHT JOIN and ON syntax for this query.

D) 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.

E) Join Customer, Relationship, and Dealership tables and display all columns. You must use INNER JOIN and ON syntax for this query.