select aa.name,aa.type,aa.way,bb.type,bb.way (select a.name,b.type,b.way from a,b where a.index=b.id) aa, (select a.name,b.type,b.way from a,b where a.purview=b.id) bb, where aa.name=bb.name
select aa.name,aa.type,aa.way,bb.type,bb.way (select a.name,b.type,b.way from a,b where a.index=b.id) aa, (select a.name,b.type,b.way from a,b where a.purview=b.id) bb, where aa.name=bb.name 对的
select aa.name,aa.type,aa.way,bb.type,bb.way from (select a.name,b.type,b.way from a,b where a.index=b.id) aa, (select a.name,b.type,b.way from a,b where a.purview=b.id) bb where aa.name=bb.name#1楼写的漏掉东西~~~
select a.name,b1.type,b1.way,b2.type,b2.way from A a,B b1,B b2 where a.index=b1.id and a.purview=b2.id
--呵呵:我也来瞎整一个: select a.name, b1.type, b1.way, b2.type, b2.way from a left join b b1 on a.index=b1.id left join b b2 on a.purview=b2.id;
(select a.name,b.type,b.way from a,b where a.index=b.id) aa,
(select a.name,b.type,b.way from a,b where a.purview=b.id) bb,
where aa.name=bb.name
(select a.name,b.type,b.way from a,b where a.index=b.id) aa,
(select a.name,b.type,b.way from a,b where a.purview=b.id) bb,
where aa.name=bb.name
对的
(select a.name,b.type,b.way from a,b where a.index=b.id) aa,
(select a.name,b.type,b.way from a,b where a.purview=b.id) bb
where aa.name=bb.name#1楼写的漏掉东西~~~
select a.name, b1.type, b1.way, b2.type, b2.way
from a left join b b1 on a.index=b1.id
left join b b2 on a.purview=b2.id;