我写了一个sql,查询外部数据源的,预览都没问题,保存时提示:
此主题相关图片如下:pic_2019-01-16_11-11-57.png
此主题相关图片如下:pic_2019-01-16_11-12-28.png
sql语句:
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'
怎么办啊?