7个回答
完整的sql复制出来
-
lin786682931 初学数据Lv2
5#
xxxl 发表于 2021-2-23 16:44
完整的sql复制出来
select MO.DOC_NO,PROJECT.PROJECT_CODE,b.ITEM_CODE,b.ITEM_SPECIFICATION,MO.PLAN_QTY,a.ITEM_CODE,a.ITEM_NAME,a.ITEM_SPECIFICATION,MO_D.REQU_INCLUDE_MULT_QTY,MO_D.ISSUED_QTY,MO_D.REQU_INCLUDE_MULT_QTY-MO_D.ISSUED_QTY wlyl,MO.PLAN_COMPLETE_DATE from MO
left join PROJECT ON MO.PROJECT_ID=PROJECT.PROJECT_ID
left join ITEM b on MO.ITEM_ID=b.ITEM_BUSINESS_ID
left join DOC on DOC.DOC_ID=MO.DOC_ID
left join MO_D on MO_D.MO_ID=MO.MO_ID
left join ITEM a on a.ITEM_BUSINESS_ID=MO_D.ITEM_ID
where DOC.DOC_CODE='5100'
and MO.STATUS<>'y' and MO.STATUS<>'Y'
and (MO_D.REQU_INCLUDE_MULT_QTY-MO_D.ISSUED_QTY)>0
lin786682931 发表于 2021-2-23 16:45
select MO.DOC_NO,PROJECT.PROJECT_CODE,b.ITEM_CODE,b.ITEM_SPECIFICATION,MO.PLAN_QTY,a.ITEM_CODE,a.I ...
把a.ITEM_CODE和b.ITEM_CODE分别取个别名再运行试试
