例如以下类型数据表
转为这样类型
sql思路,先将每一类型的行列出来,然后用inner join
关联
select a.id,qylx,qyrdsj, zjzzqjkjcxtd, qyrdsj ,tdmc,tdrdsj,
zjgjhzzqjyfpt,plantask,finishtask,approveTime from
(select m.id,j.situation qylx,j.confirmationTime2 qyrdsj
from PMS_MONITORS_STATISTICS m
left join PMS_JXDC_OTHERINFO j on m.id = j.projectbaseid
where j.type = '科技型企业'
) a
inner join
(select m.id,m.zjzzqjkjcxtd,j.situation as tdmc,j.confirmationTime2 as tdrdsj
from PMS_MONITORS_STATISTICS m
left join PMS_JXDC_OTHERINFO j on m.id = j.projectbaseid
where j.type = '团队') b on a.id=b.id
inner join
(select m.id,m.zjgjhzzqjyfpt,j.plantask,j.finishtask ,j.approveTime
from PMS_MONITORS_STATISTICS m