Question

1. Write an SQL statement to join EMPLOYEE, ASSIGNMENT, and PROJECT using the JOIN ON syntax. Run this statement.

2. Write an SQL statement to join EMPLOYEE and ASSIGNMENT and include all rows of EMPLOYEE in your answer, regardless of whether they have an ASSIGNMENT. Run this statement.

I have been working on these two questions for the last 3 hours and I cannot get Microsoft Access 2016 to Run them without an error message coming up.

Answer 1

If you have any doubts, please give me comment...

1)

SELECT *

FROM EMPLOYEE E JOIN ASSIGNMENT A ON E.Ssn = A.Ssn JOIN PROJECT P ON E.Ssn = P.Ssn;

2)

SELECT *

FROM EMPLOYEE E LEFT OUTER JOIN ASSIGNMENT ON E.Ssn = A.Ssn;

Note:

The columns might be mismatch... Please provide schema for better results... I will help you...