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

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

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

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


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

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


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

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