SEL ECT a._Identify, a._Locked, a._SortKey, a.交接单号, a.接收日期, a.单据证明, a.说明, a.制单日期, a.制单RID, a.接收RID, a.交接确认, a.制单BMID, a.接收BMID, b.sn,
b.排产ID, b.数量, c.代码, c.名称, c.规格型号, c.生产单号, c.备品数量, c.拼板补数, c.样板数量, c.需求数量, c.排产单号, c.产品名称, b.总表ID, n1.Name AS 制单人,
N2.Name AS 接收人, x1.显示值 AS 制单部门, x2.显示值 AS 接收部门, (CASE a.交接确认 WHEN 1 THEN 'Y' END) AS 审核标志,
(SE LECT SUM(数量) AS Exp
FROM dbo.生产交接单明细 AS x
WHERE (排产ID = b.排产ID) AND (_Identify <> _Identify)) AS 已交接数, b.Itid
FROM dbo.生产交接单总表 AS a LEFT OUTER JOIN
dbo.下拉表 AS x1 ON a.制单BMID = x1.ID LEFT OUTER JOIN
dbo.下拉表 AS x2 ON a.接收BMID = x2.ID LEFT OUTER JOIN
dbo.Users AS N2 ON a.接收RID = N2.useid LEFT OUTER JOIN
dbo.Users AS n1 ON a.制单RID = n1.useid LEFT OUTER JOIN
dbo.生产交接单明细 AS b ON b.总表ID = a.Itid LEFT OUTER JOIN
dbo.SMT_DDPC AS c ON c.ItID = b.排产ID
加好友 
发短信
Post By：2020/7/29 17:34:00 [只看该作者]
