select t1.field,t2.field from (select a.*,rownum as r1 from a) t1, (select b.*,rownum as r2 from b) t2 where t1.r1=t2.r2
而且 记录也非常大也不能用左右连接之后在UNION
象access的交叉表,可以用case end 、decode之类的试试
select t.id || t.t_id || tt.id || tt.t_id from (select rownum r_a,a.* from testa a) t full outer join(select rownum r_b,b.* from testb b) tt on ( t.r_a = tt.r_b )
(select a.*,rownum as r1 from a) t1,
(select b.*,rownum as r2 from b) t2
where t1.r1=t2.r2