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 10:27:00 [显示全部帖子]
