内联只能连一个
FROM DISPATCHLIST DL, DISPATCHLISTS DLS
INNER JOIN CUSTOMER C ON C.cCusCode=DL.cCusCode
LEFT OUTER JOIN SalePayVouch SPV ON DL.cCusCode=SPV.cCusCode
LEFT OUTER JOIN SalePayVouchS SPVS ON SPVS.ID=SPV.ID
LEFT OUTER JOIN AP_CLOSEBILL ACB ON DL.cCusCode =ACB.cDwCode
WHERE DL.DLID=DLS.DLID
group by c.cCusAbbName,DLS.iTaxUnitPrice
order by c.cCusAbbName
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024