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