--October 29, 2009 In Examples

set echo on

SELECT * from branch 
where branch_name in
(select branch_name from loan);

--must have correct schema
SELECT * from branch 
where branch_name in
(select customer_street from customer);

SELECT * from branch 
where branch_name in
(select account_number from account);