mysql7个字段怎么用左连接求出另一张表的和
select count(qtym2),c1.zgx1 from lsh_plan,(select count(qtym2) AS zgx1 from lsh_plan
left join w.wip
on lsh_plan.process=wip.process and (LSH_PLAN.Ledger1 =w.wip.ledger or LSH_PLAN.Ledger2 =w.wip.ledger or LSH_PLAN.Ledger3 =w.wip.ledger or LSH_PLAN.Ledger4 =w.wip.ledger or LSH_PLAN.Ledger5 =w.wip.ledger) group by id ) as c1
left join w.wip
on lsh_plan.gx2=wip.process and (LSH_PLAN.Ledger1 =w.wip.ledger or LSH_PLAN.Ledger2 =w.wip.ledger or LSH_PLAN.Ledger3 =w.wip.ledger or LSH_PLAN.Ledger4 =w.wip.ledger or LSH_PLAN.Ledger5 =w.wip.ledger) group by id
例如: select *from CT_CYK_CustomerBaseInfoLEFT OUTER JOIN T_BD_Customer ON CT_CYK_CustomerBaseInfo.CFCustNameID=T_BD_Customer.FIDand CT_CYK_CustomerBaseInfo.CFMainLinkMenID=T_BD_Customer.FID;把客户的基本信息表进行的重新命名,然后修改了sql语句,取得成功,结果如下:select *from CT_CYK_CustomerBaseInfoLEFT OUTER JOIN T_BD_Customer ON CT_CYK_CustomerBaseInfo.CFCustNameID=T_BD_Customer.FIDLEFT OUTER JOIN T_BD_Customer as linkpeople ONCT_CYK_CustomerBaseInfo.CFMainLinkMenID=linkpeople.FID;这样就实现了在一个数据库表中同时两次左联接。