无标题1.sql

集成酒店桑拿食管管理的完整程序

select a.name as 名称,a.cuscode AS 商品编号,a.innum AS 本班调入,b.xsnum as 上班销售,b.outnumwj AS 上班未结,b.sjnum AS 上班实存,a.xsnum AS 本班销售,a.outnumwj AS 本班未结,a.sjnum AS 现有数量
from zdpkls as a,zdpk as b where a.spcode=b.spcode and b.regtime='03-3-17 18:32:49'