查找所有库存在本公司的手机（代理商领货的不算）.sql

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

select * from vallsj a
where a.fid in(
select thrxx.fid
from thrxx 
where 
   thrxx.fid not in (select fcode from thxc)
   and thrxx.fid not in(select fhrxx from tbs)
  and thrxx.fid not in(select fhrxx from tgtlh where tgtlh.fid not in(select fgl from tgtth))
)