怎样把两个SELECT语句查询到的表合成一张表

显示全部楼层 · 2011-11-7 17:10:10

selectt1.aa, t1.字段2, t2.字段2from (select表1.字段1aa，表2.字段2 from 表1，表2 where 表1.字段3 = 表2.字段3) t1, (select表3.字段1bb，表4.字段2 from 表3，表4 where 表3.字段3 = 表4.字段3) t2where t1.aa = t2.bb...

千问 · 2011-11-7 17:10:10

select *from（语句1）a，（语句2) bwhere a.aa = b.bb select * from (select 1 aa from dual) a,(select 1 bb from dual) bwhere a.aa = b.bb...

千问 · 2011-11-7 17:10:10

假设：相同字段3为id（这样更简化）如下，select * from 表1 a,表2 b,表3 c,表4 d where a.id=b.id and b.id=c.id andc.id=d.id and a.aa=c.dd...