Joining sql views in oracle sql

These will be distinct result sets as the libname is different so use UNION ALL rather than UNION

SELECT * FROM florence_staffUNION ALLSELECT * FROM alexandria_staff

CodeHunter