You are a database developer for Contoso, Ltd. The company has a database named HumanResources that contains information about all employees and office locations. The database also contains information about potential employees and office locations. The tables that ontain this information are shown in the exhibit. Current employees are assigned to a location, and current locations have one or more employees assigned to them. Potential employees are not assigned to a location, and potential office locations do not have any employees assigned to them. You need to create a report to display all current and potential employees and office locations. The report should list each current and potential location, followed by any employees who have been assigned to that location. Potential employees should be listed together. Which script should you use?

40.

You are a database developer for Contoso, Ltd.
The company has a database named HumanResources that contains information about all employees and office locations.
The database also contains information about potential employees and office locations.
The tables that ontain this information are shown in the exhibit.
Current employees are assigned to a location, and current locations have one or more employees assigned to them.
Potential employees are not assigned to a location, and potential office locations do not have any employees assigned to them.
You need to create a report to display all current and potential employees and office locations. The report should list each current and potential location, followed by any employees who have been assigned to that location.
Potential employees should be listed together.

Which script should you use?

SELECT L.LocationName, e.FirstName, e.LastName FROM Employee AS e LEFT OUTER JOIN Location L AS 1ON e.LocationID= L.LocationID ORDER BY L.LocationName, e.LastName, e.FirstName

SELECT L.LocationName, e.FirstName, e.LastName FROM Location AS L LEFT OUTER JOIN EMPLOYEE AS L ON e.LocationID= L.LocationIDORDER BY L.LocationName, e.LastName, e.FirstName

SELECT L.LocationName, e.FirstName, e.LastNameFROM Employee AS e FULL OUTER JOIN Location AS L ON e.LocationID= L.LocationID ORDER BY L.LocationName, e.LastName, e.FirstName

SELECT L.LocationName, e.FirstName, e.LastName FROM Employee AS e CROSS JOIN Location AS L ORDER BY L.LocationName, e.LastName, e.FirstName

View Description

No description found.