View source for Yurttas/PL/DBL/mysql/F/01/00/bank/Bank/q04.sql

← Yurttas/PL/DBL/mysql/F/01/00/bank/Bank/q04.sql

Jump to navigation Jump to search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: writer.

You can view and copy the source of this page.

<syntaxhighlight lang="sql" line start="1" enclose="div">/*
REM
REM q04.sql
REM
REM Suppose we want a relation showing customers and the branches
REM from which they borrow, but do not care about the amount of
REM the loan, or the loan number.
REM
*/

\. set-db.sql

SELECT branchname, customername
FROM Borrower;
</syntaxhighlight>

Return to Yurttas/PL/DBL/mysql/F/01/00/bank/Bank/q04.sql.

Retrieved from "http://wiki.zcubes.com/Yurttas/PL/DBL/mysql/F/01/00/bank/Bank/q04.sql"