34,837
社区成员




select a.*, c.*, e.* from
a inner join
(b inner join
(c inner join
(d inner join e on d.eid = e.eid ) <<-- 嵌套这行是记录就不完了,请问为什么
on c.cid = d.eid)
on b.cid = c.cid)
on a.aid = b.aid
select a.*,c.* from a
inner join b on a.aid=b.aid
inner join c on b.cid=c.cid
inner join d on c.cid=d.eid <--- 内联d表时,无记录(d表为c表与e表的多对多关系表)
select a.*,c.*,e.* from
a inner join b on a.aid=b.aid inner join c on b.cid=c.cid
inner join d on c.cid=d.eid inner join e on d.eid=e.eid
select a.*,c.*,e.* from
a inner join b on a.aid=b.aid innser join c on b.cid=c.cid
innser join d on c.cid=d.eid inner join e on d.eid=e.eid