Using Access, write 5 separate SQL queries, named “Query31” through “Query35”. Each query will contain a SQL statement that is your solution for the translation of a “plain English” request.
Each query is worth one point.
For Query31 through Query35, you must put the join criteria in the ON clause.
31. Join Dealership and Employee tables and display all columns. You must use INNER JOIN and ON syntax for this query.
32. 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.
33. 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.
34. 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.
Join Customer, Relationship, and Dealership tables and display all columns. You must use INNER JOIN and ON syntax for this query
