对于多个基表不支持动态 SQL 生成 Post By：2013/8/26 9:44:00 [只看该作者]
SELECT A.Order_No,A.Material_No,A.Material_Name,ISNULL(A.Order_Qty,0.000000)-ISNULL(B.Current_RecQty,0.000000) AS Order_Qty,A.Stock_Uom FROM MD A LEFT outer JOIN (SELECT Ref_No,Order_No,Current_RecQty FROM Order_RecD WHERE Confirms=1) B ON A.Order_No=B.Order_No Table的fill不支持这样的语句吗？
加好友 
发短信
Post By：2013/8/26 9:44:00 [只看该作者]
