SELECT c.fsjxh, COUNT(*) AS total
FROM (SELECT tbs.fhrxx
        FROM tbs
        WHERE tbs.fhrxx NOT IN
                  (SELECT fhrxx
                 FROM thhdd) AND tbs.fid NOT IN
                  (SELECT fbs
                 FROM tbsfh)
--在這里面設定日期段，
--則可以查出這一時段的所有的因為退貨而沒有返回的機子，
--也就是說還存在經銷商那兒沒有返回的機子
) b INNER JOIN
      dbo.thrxx r ON b.fhrxx = r.fid INNER JOIN
      dbo.thrc c ON r.fhrcid = c.fid
GROUP BY c.fsjxh