General discussion

Locked

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;
Go

--1
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.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to After Hours Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums