17,377
社区成员
发帖
与我相关
我的任务
分享
select
a.id,
(select min(c.coll_nm) from b,c where a.lmt_no=b.lmt_no and b.coll_no=c.coll_no group by b.lmt_no),
(select min(d.ci_nm) from d where a.pro_no=d.ci_no group by d.ci_no),
(select e.ci_nm from e where a.ci_no=e.ci_no )
.......
from a
select
a.id,min(c.coll_nm), min(d.ci_nm),e.ci_nm
from a
left join b on a.lmt_no=b.lmt_no
left join c on b.coll_no=c.coll_no
left join d on a.pro_no=d.ci_no
left join e on a.ci_no=d.ci_no
.......
group by b.lmt_no,d.ci_no
select
a.id,coll.coll_nm, pro.ci_nm,e.ci_nm
from a
left join (
select min(c.coll_nm) coll_nm,b.lmt_no
from b,c
where b.coll_no=c.coll_no
group by b.lmt_no) coll
on a.lmt_no=coll.lmt_no
left join (
select min(d.ci_nm) pro_nm
from d
group by d.ci_no) pro
on pro.pro_no=d.ci_no
left join e on a.ci_no=d.ci_no
.......
select
a.id,min(c.coll_nm), min(d.ci_nm),e.ci_nm
from a
left join b on a.lmt_no=b.lmt_no
left join c on b.coll_no=c.coll_no
left join d on a.pro_no=d.ci_no
left join e on a.ci_no=d.ci_no
.......
group by b.lmt_no,d.ci_no