After Hours

General discussion


SQL-Missing Query results data

By bphibbs.79 ·
Tags: Off Topic
Can anyone help me figure out what I did or didn't do to get no results? I executed the query and it says it has done successfully, yet the tables do not contain any data.

/*Display all those employees holding a Manager’s job title and their hire dates.
Include the First and Last Name, the job title, and the hire date.*/ <<<This is what I am looking for in my end result. Below is my code.

Use AdventureWorks2012;

Select Employee.JobTitle, Employee.HireDate, Person.FirstName, Person.LastName, Person.PersonType
From HumanResources.Employee
Full Outer Join Person.Person ON PersonType=JobTitle
Where JobTitle = 'Manager';

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums