Yurttas/PL/DBL/postgres/F/01/Bank/q04.sql

 1/*
 2REM
 3REM q04.sql
 4REM
 5REM Suppose we want a relation showing customers and the branches
 6REM from which they borrow, but do not care about the amount of
 7REM the loan, or the loan number.
 8REM
 9*/
10
11SELECT current_schema();
12SET search_path to "bank";
13
14SELECT branchname, customername
15FROM Borrower;