SELECT B14_OrderType, B14_OrderID,
B14_LineNo, NULL, NULL, NULL, NULL, NULL, NULL, B14_SecondItemID,
B14_Address, B14_OrderQty, B14_UnitPrice, B14_FCUnitPrice,
(B14_OrderQty - B14_ArrivalQty) AS UndeliveredQty, '2' AS FLG
FROM B14_JDEOrderRemained
except
SELECT B14_OrderType, B14_OrderID,
B14_LineNo, NULL, NULL, NULL, NULL, NULL, NULL, B14_SecondItemID,
B14_Address, B14_OrderQty, B14_UnitPrice, B14_FCUnitPrice,
(B14_OrderQty - B14_ArrivalQty) AS UndeliveredQty, '2' AS FLG
FROM B14_JDEOrderRemained INNER JOIN
B10_OrderRemained ON B10_OrderNo = B14_OrderID AND
B10_LineNo = B14_LineNo AND B10_OrderType = B14_OrderType为什么每次执行前先报这msg,确定后出结果
The EXCEPT SQL construct or statement is not supported.
什么原因阿,怎么修正
B14_LineNo, NULL, NULL, NULL, NULL, NULL, NULL, B14_SecondItemID,
B14_Address, B14_OrderQty, B14_UnitPrice, B14_FCUnitPrice,
(B14_OrderQty - B14_ArrivalQty) AS UndeliveredQty, '2' AS FLG
FROM B14_JDEOrderRemained
except
SELECT B14_OrderType, B14_OrderID,
B14_LineNo, NULL, NULL, NULL, NULL, NULL, NULL, B14_SecondItemID,
B14_Address, B14_OrderQty, B14_UnitPrice, B14_FCUnitPrice,
(B14_OrderQty - B14_ArrivalQty) AS UndeliveredQty, '2' AS FLG
FROM B14_JDEOrderRemained INNER JOIN
B10_OrderRemained ON B10_OrderNo = B14_OrderID AND
B10_LineNo = B14_LineNo AND B10_OrderType = B14_OrderType为什么每次执行前先报这msg,确定后出结果
The EXCEPT SQL construct or statement is not supported.
什么原因阿,怎么修正
http://blog.csdn.net/precipitant/archive/2006/11/28/1418124.aspx