--October 29, 2009 Intersect Examples

set echo on


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

SELECT * from account 
intersect
select * from branch;

SELECT * from loan 
intersect
select * from branch;

SELECT * from customer 
intersect
select * from branch;

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