34,590
社区成员
发帖
与我相关
我的任务
分享
select a.fenshu,b.class,c.subject,d.test,e.name
from aa a,bb b,cc c, dd d,ee e
where a.bb_id=b.bb_id and a.cc_id=c.cc_id and a.dd_id=d.dd_id and a.ee_id=e.ee_id
and b.bb_id='33'
select a.aa_id,a.bb.id,a.cc_id,a.dd_id,a.ee_id,a.fenshu
from aa a
left join bb b on b.bb_id=a.bb_id
left join cc c on c.cc_id=a.bb_id
left join dd d on d.dd_id=a.bb_id
left join ee e on e.ee_id=a.ee_id
where b.bb_id='33'
select a.fenshu,b.class,c.subject,d.test,e.name
from aa a
left join bb b on b.bb_id=a.bb_id and b.bb_id='33'
left join cc c on c.cc_id=a.cc_id
left join dd d on d.dd_id=a.dd_id
left join ee e on e.ee_id=a.ee_id
select a.fenshu,b.class,c.subject,d.test,e.name
from aa a
left join bb b on b.bb_id=a.bb_id
left join cc c on c.cc_id=a.cc_id
left join dd d on d.dd_id=a.dd_id
left join ee e on e.ee_id=a.ee_id
where b.bb_id='33'