home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The C Users' Group Library 1994 August
/
wc-cdrom-cusersgrouplibrary-1994-08.iso
/
listings
/
v_02_08
/
2n08061b
< prev
next >
Wrap
Text File
|
1991-05-14
|
452b
|
19 lines
CREATE VIEW apptally(region#, appcount, fundcount)
AS SELECT region#, COUNT(appdate), 0
FROM Loans
WHERE appdate BETWEEN 1991-Apr-01 AND 1991-Apr-30
GROUP BY region#;
CREATE VIEW fundtally(region#, appcount, fundcount)
AS SELECT region#, 0, COUNT(funddate)
FROM Loans
WHERE funddate BETWEEN 1991-Apr-01 AND 1991-Apr-30
GROUP BY region#;
SELECT * FROM apptally
UNION ALL
SELECT * FROM fundtally
ORDER BY 1;