select a.状态 from
(
select * from 表1
union
select * from 表2
union
select * from 表3
) a
where a.状态时间 in (select max(状态时间) from
(
select * from 表1
union
select * from 表2
union
select * from 表3
) b ))
(
select * from 表1
union
select * from 表2
union
select * from 表3
) a
where a.状态时间 in (select max(状态时间) from
(
select * from 表1
union
select * from 表2
union
select * from 表3
) b ))
v_state varchar2;
begin
select max( 状态时间) into v_rq from
(
select * from 表1
union
select * from 表2
union
select * from 表3
) a;
select a.状态 into v_state from
(
select * from 表1
union
select * from 表2
union
select * from 表3
) a;return v_state; end;