[Solved] ICSI410 Assignment 4

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.
35. Join Customer, Relationship, and Dealership tables and display all columns. You must use INNER JOIN and ON syntax for this query.

The rules for assignment #1, #2, and #3 are still in effect for this assignment with an important modification:

All joins must be done by matching the appropriate columns in the ON clause. In other words, you must use INNER, LEFT, or RIGHT JOIN and ON syntax to perform the join operation otherwise you will get no credit for your solution.