/***************************************
得出所有的訂貨單中，每一個訂貨單的ID的退庫情況
*****************************************/
select thrc.fid,count(*)
FROM tbs,thrxx,thrc
 WHERE  thrxx.fhrcid=thrc.fid and tbs.fhrxx =thrxx.fid and (dbo.tbs.fhrxx NOT IN
          (SELECT fhrxx
         FROM thhdd)) AND (dbo.tbs.fhrxx NOT IN
          (SELECT fhrxx
         FROM tkhth))and tbs.fid not in(select fbs from tbsfh)
group by thrc.fid