rinneii
New Member
- Joined
- Mar 20, 2019
- Messages
- 18
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?
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?