J
jackyy
Unregistered / Unconfirmed
GUEST, unregistred user!
select a.发票名称,sum(b.份数-c.交回份数) as 当前可用份数,a.最低库存 from fp a,lq b,ff c
where a.发票编号=b.发票编号 and b.归档=false and b.编号=c.编号 group by a.发票名称,a.最低库存
having sum(b.份数-c.交回份数) <= a.最低库存
where a.发票编号=b.发票编号 and b.归档=false and b.编号=c.编号 group by a.发票名称,a.最低库存
having sum(b.份数-c.交回份数) <= a.最低库存