Yurttas/PL/DBL/mssql/F/01/Bank/u08.sql

 1/*
 2REM
 3REM u08.sql
 4REM
 5REM Suppose that we want to provide all loan customers in the
 6REM Perryridge branch with a $200 savings account.
 7REM (Let the loannumber serve as the accountnumber
 8REM  for the new savings account.)
 9REM
10*/
11
12INSERT INTO Depositor
13  SELECT branchname, loannumber, customername, 200
14  FROM Borrower
15  WHERE branchname = 'Perryridge';