Which Transact-SQL code statement should you run?

You are developing a database to track employee progress relative to training goals. You run the following Transact-SQL statements: You must build a report that shows all Employees and the courses that they have taken. Employees that have not taken training courses must still appear in the report. The report must display NULL in the course column for these employees.

You need to create a query for the report.

Which Transact-SQL code statement should you run?

View Answer

Answer: D

Explanation:

Employee data should be there and employee is in the end and Left join gives complete set on left side not on the right side

Incorrect Answers: A, B: JOIN and INNER JOIN displays only the rows that have a match in both joined tables

C: Employee data should be there and employee is in the end and Left join gives complete set on left side not on the right side

References: https://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/