Create Queries in SQL Statements that work in Microsoft Access A) Join Dealershi
ID: 3698380 • Letter: C
Question
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.
***Use DISTINCT when necessary, but do not specify DISTINCT when it’s not needed.
Relationships Invoice Purchaser Employee Vehicle Customer Dealership 9 dstate RelationshipExplanation / Answer
a) SELECT *
FROM Dealership
INNER JOIN Employee ON Dealership.dcode = Employee.ecode;
b) SELECT *
FROM Dealership
LEFT JOIN Employee ON Dealership.dcode = Employee.ecode;
c) SELECT *
FROM Dealership
RIGHT JOIN Employee ON Dealership.dcode = Employee.code;
d) SELECT *
FROM Dealership
FULL OUTER JOIN Employee ON Dealership.dcode = Employee.ecode;
e) SELECT *
FROM((Relationship INNER JOIN on Dealership.dcode = Realtionship.rcode )
INNER JOIN Customer ON Relationship.rcid = Customer.cid );