CREATE TABLE TEST01
(COL1 INTEGER,
CUR_TRN_DT TIMESTAMP);
commit;

INSERT INTO TEST01 VALUES (1, '1993-12-1 12:00:00');
INSERT INTO TEST01 VALUES (2, '1993-12-31 12:00:00');
commit;


CREATE TABLE TEST02
(COL1 INTEGER,
CUR_TRN_DT TIMESTAMP);
commit;

INSERT INTO TEST02 VALUES (1, '1994-12-1 12:00:00');
INSERT INTO TEST02 VALUES (2, '1994-12-31 12:00:00');
commit;


CREATE TABLE TEMP01(
	COLA	INTEGER(4), 
	WJXBFS1	DATE, 
	WJXBFS2	DATE);
commit;

insert into TEMP01
select	0  COLA,
	max(a11.CUR_TRN_DT)  WJXBFS1,
	min(a11.CUR_TRN_DT)  WJXBFS2
from	TEST01	a11;
commit;


insert into TEMP01 
select	1  COLA,
	max(a11.CUR_TRN_DT)  WJXBFS1,
	min(a11.CUR_TRN_DT)  WJXBFS2
from	TEST02	a11;
commit;

create index TEMP01_i on TEMP01 (COLA);
commit;

select	pa11.COLA  COL_ID,
	max(pa11.WJXBFS1)  WJXBFS1,
	min(pa11.WJXBFS2)  WJXBFS2,
	(max(pa11.WJXBFS1) - min(pa11.WJXBFS2))  WJXBFS3
from	TEMP01	pa11
GROUP BY COLA;