The C Users' Group Library 1994 August/wc-cdrom-cusersgrouplibrary-1994-08.iso/listings/v_02_08/2n08061b

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;