S ELECT ROW_NUMBER() OVER (ORDER BY a.DOC_DATE ASC) AS [序列], CONVERT(VARCHAR(10),a.DOC_DATE,120) AS [单据日期],
CONVERT(VARCHAR(10),a.ApproveDate,120) AS [审核日期],
a.SUPPLIER_FULL_NAME AS [供应商], c.EMPLOYEE_NAME AS [负责人员], d.ADMIN_UNIT_NAME AS [部门],
e.WAREHOUSE_NAME AS [限定仓库], a.REMARK AS [备注],
f.ITEM_CODE AS [品号], b.ITEM_DESCRIPTION AS [品名], b.ITEM_SPECIFICATION AS [规格],
b.BUSINESS_QTY AS [数量], g.UNIT_NAME AS [单位],
h.PRICE_QTY AS [单价],
i.WAREHOUSE_NAME AS [仓库], j.LOT_CODE AS [批号]

F ROM dbo.{PURCHASE_RECEIPT} a JOIN dbo.{PURCHASE_RECEIPT_D} b ON b.PURCHASE_RECEIPT_ID = A.PURCHASE_RECEIPT_ID
 JOIN dbo.{EMPLOYEE} c ON c.EMPLOYEE_ID = a.Owner_Emp
 JOIN dbo.{ADMIN_UNIT} d ON d.ADMIN_UNIT_ID = a.Owner_Dept
 JOIN dbo.{WAREHOUSE} e ON e.WAREHOUSE_ID = a.WAREHOUSE_ID
 JOIN dbo.{ITEM} f ON f.ITEM_BUSINESS_ID = b.ITEM_ID
 JOIN dbo.{UNIT} g ON g.UNIT_ID = b.BUSINESS_UNIT_ID
 JOIN dbo.{PURCHASE_ARRIVAL_D} h ON h.PURCHASE_ARRIVAL_D_ID = b.SOURCE_ID
 JOIN dbo.{WAREHOUSE} i ON i.WAREHOUSE_ID = b.WAREHOUSE_ID
 LEFT JOIN dbo.{ITEM_LOT} j ON j.ITEM_LOT_ID = b.ITEM_LOT_ID
WHERE A.DOC_NO = \'A121-2019011408\'

怎么办啊?