home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The C Users' Group Library 1994 August
/
wc-cdrom-cusersgrouplibrary-1994-08.iso
/
listings
/
v_02_08
/
2n08061a
< prev
next >
Wrap
Text File
|
1991-05-14
|
377b
|
13 lines
CREATE VIEW appview(loan#, region#, appdate, funddate)
AS SELECT loan#, region#, appdate, CAST DATE AS NULL
FROM Loans
WHERE appdate BETWEEN 1991-Apr-01 AND 1991-Apr-30;
CREATE VIEW fundview(loan#, region#, appdate, funddate)
AS SELECT loan#, region#, CAST DATE AS NULL, funddate
FROM Loans
WHERE funddate BETWEEN 1991-Apr-01 AND 1991-Apr-30;