SQL: Union

[rinneii]

I'm trying to list both Student and Faculty information using the Union operator. This is what I have so far:

SELECT FacNo, FacFirstName, FacLastName
From Faculty
UNION Select StdNo, stdFirstName, stdLastName
From Student;

When I ran it, all that displayed was the Faculty information. Should I be using Union All?

 

[xenou]

Just to be clear: the first query is completely correct (post #1 ) and should work with Union or with Union All.

One possibly source of confusion: The union query will display the header from the first part (FacNo, FacFirstName, FacLastName). So the query will show a listing of Faculty data that is really a listing of Faculty data and student data.

So possibly better in terms of semantics is:

SELECT FacNo as ID, FacFirstName as FirstName, FacLastName as LastName
From Faculty
UNION Select StdNo as ID, stdFirstName as FirstName, stdLastName as LastName
From Student;

which will give a combined listing of Faculty and Students without a confusing header that would label them all as faculty.