select 入库表.编号 as 库存表.编号,sum(入库表.数量)-sum(出库表.数量) as 库存表.数量 from 入库表 left join 出库表 on 入库表.编号=出库表.编号 group by 编号
select wayreceive.wrpartno as wspartno,sum(wayreceive.wrnum)-sum(waysend.wsnum) as wsokqty from wayreceive,waysend where wayreceive.wrpartno = waysend.wspartno group by wspartno union select wayreceive.wrpartno , wrnum from wayreceive left join waysend on wayreceive.wrpartno = waysend.wspartno where waysend.wspartno is null group by wrpartno
to xuzuning(唠叨) 当在出库表中没有出现的编号,在你的语句中是查不到数量的。 leiz02(leiz) 的是可以查的,但看起来没有上面的简洁了。
as 库存表.编号,sum(入库表.数量)-sum(出库表.数量) as 库存表.数量 from 入库表 left join 出库表 on 入库表.编号=出库表.编号 group by 编号
as wspartno,sum(wayreceive.wrnum)-sum(waysend.wsnum) as wsokqty from wayreceive,waysend
where wayreceive.wrpartno = waysend.wspartno group by wspartno
union
select wayreceive.wrpartno , wrnum from wayreceive left join waysend on wayreceive.wrpartno = waysend.wspartno
where waysend.wspartno is null group by wrpartno
当在出库表中没有出现的编号,在你的语句中是查不到数量的。
leiz02(leiz) 的是可以查的,但看起来没有上面的简洁了。