查询所有的手机串号入库流水号id的库存的id.sql

手机进销存系统Delphi源码,管理手机的进货还有销售方面的功能

select thrxx.fid,thrxx.fmon 
from thrxx,thrc
where  thrxx.fhrcid=thrc.fid and thrxx.fid not in (select fcode from thxc ) and thrxx.fid not in (select fhrxx from tbs)
order by  thrxx.fid