CREATE VIEW DSN8B10.FIRSTQTR (SNO, CHARGES, DATE) AS SELECT SNO, CHARGES, DATE FROM MONTH1 WHERE DATE BETWEEN '01/01/2000' and '01/31/2000' UNION All SELECT SNO, CHARGES, DATE FROM MONTH2 WHERE DATE BETWEEN '02/01/2000' and '02/29/2000' UNION All SELECT SNO, CHARGES, DATE FROM MONTH3 WHERE DATE BETWEEN '03/01/2000' and '03/31/2000';