查看所有的手机串号入库流水号，没有销出去的所有串号入库流水号.sql

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

--查看所有的手机串号入库流水号，没有销出去的所有串号入库流水号
declare @hrcid char(12)
SELECT TOP 100 PERCENT dbo.thrxx.fno, dbo.thrxx.fid AS fid, dbo.tcolor.fcolor, 
      dbo.thrc.fdate, LTRIM(RTRIM(dbo.tsjcs.fna)) + LTRIM(RTRIM(dbo.tsjxh.fmodel)) 
      AS fsjxh, dbo.tjbpz.fname AS fjbpz, dbo.thyd.fna AS fhyd, dbo.tsjxh.fgl, 
      dbo.thylx.fname AS fhylx
FROM dbo.tcolor INNER JOIN
      dbo.thrxx ON dbo.tcolor.fid = dbo.thrxx.fcolor INNER JOIN
      dbo.tsjxh INNER JOIN
      dbo.tsjcs ON dbo.tsjxh.fsjcs = dbo.tsjcs.fid INNER JOIN
      dbo.thrc ON dbo.tsjxh.fid = dbo.thrc.fsjxh INNER JOIN
      dbo.tjbpz ON dbo.thrc.fjbpz = dbo.tjbpz.fid INNER JOIN
      dbo.thylx ON dbo.thrc.fhylx = dbo.thylx.fid INNER JOIN
      dbo.thyd ON dbo.thrc.fhyd = dbo.thyd.fid ON dbo.thrxx.fhrcid = dbo.thrc.fid
WHERE (dbo.thrxx.fid NOT IN
          (SELECT fhrxx
         FROM tbs)) AND (dbo.thrxx.fid NOT IN
          (SELECT fcode
         FROM thxc)) and thrc.fid=@hrcid
ORDER BY dbo.tcolor.fid