/* Adding one table to the end of another table */

SELECT fname, lname from student
UNION
SELECT fname, lname from instructor;



/* A Better example. */
/* Adding an identifier to know which table data comes from */

SELECT 'student', fname, lname from student
UNION
SELECT 'instructor', fname, lname from instructor
order by lname, fname;



/* What if the columns requested are not the same number - use null */
SELECT 'student',    fname, lname, ssn, null as gender 
from student
UNION
SELECT 'instructor', fname, lname, null, sex 
from instructor
order by lname, fname;