--October 29, 2009 Union Examples

set echo on

SELECT * from account; 

select * from branch;

select * from loan;


--need to have same schema
--with Oracle - not necessarily same names

SELECT * from account 
union
select * from branch;

SELECT * from loan 
union
select * from branch;

SELECT * from customer 
union
select * from branch;

--already distinct 
select branch_name from loan
union
select branch_name from branch;

select distinct * from
(select branch_name from loan
union
select branch_name from branch
);