Tables("窗口1_Table1").fill("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","EPN数据",True)