12 lines
334 B
SQL
12 lines
334 B
SQL
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'; |