20CN网络安全小组论坛 - 编程破解 - 养护贴标SQL代码（原创）

论坛: 编程破解标题: 养护贴标SQL代码（原创）

作者: SCANDISK [scandisk]

论坛用户

select c.warename as 商品名称,c.warespec as 规格,c.wareunit as 单位,c.producer as 生产厂家,a.makeno as 批号,b.sum_makeqty as 库存数量
from u_maintain_c a,u_store_make b,u_ware_q c
where a.wareid=b.wareid and a.check_okqty>=300 and b.sum_makeqty>=300 and a.wareid=c.wareid and a.maintainno='2109130001001' and a.makeno=b.makeno
order by b.sum_makeqty desc

地主发表时间: 21-09-15 01:43

论坛: 编程破解