Yurttas/PL/DBL/mysql-f-2010/01/BankOne/v01.sql
Revision as of 01:52, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM v01.sql REM REM Consider a view consisting of REM branch names and the names of customers. REM: /* th...")
1/*
2REM
3REM v01.sql
4REM
5REM Consider a view consisting of
6REM branch names and the names of customers.
7REM
8*/
9
10/*
11
12 this won't work
13
14*/
15
16\. set-db.sql
17
18CREATE VIEW AllCustomer
19 AS (SELECT branchname, customername
20 FROM Depositor)
21 UNION
22 (SELECT branchname, customername
23 FROM Borrower);