同样的代码（select语句），为什么第一个代码能执行，后面的代码总提示错误，困扰两天了，都是一样的啊，就是表不同而已！
DataTables("库存清单").Fill("Select {派工号}.型号, {销售单}.数量 As 销售_数量,{销售单}.售价/{销售单}.数量 As 销售_均价,{销售单}.售价 As 销售_售价 fro m ((Select 型号 fro m {派工号} group by 型号) As {派工号}
left join (Select 型号,sum(数量) As 数量,sum(售价) As 售价 fro m {销售单} group by 型号) As {销售单} on {销售单}.型号 = {派工号}.型号)",True)
上面这段代码能执行
DataTables("库存清单").Fill("Select {派工号}.型号, {进货单}.数量 As 进货_数量,{进货单}.单价 As 进货_单价, {进货单}.单价 * {进货单}.数量 As 进货_金额 fro m
((Select 型号 fro m {派工号} group by 型号) As {派工号} left join (Select 型号,单价,sum(数量) As 数量fro m {进货单} group by 型号) As {进货单} on
{进货单}.型号 = {派工号}.型号)",True)
这段代码执行不了。
加好友 
发短信
Post By：2016/10/12 9:39:00 [只看该作者]
