Yurttas/PL/DBL/mssql/F/01/Bank/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
16CREATE VIEW AllCustomer
17  AS (SELECT branchname, customername
18      FROM Depositor)
19     UNION
20     (SELECT branchname, customername
21      FROM Borrower);