Yurttas/PL/DBL/mysql/F/01/00/bank/BankOne/v01.sql

 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);