SELECT DISTINCT 
      dbo.thrxx.fid AS fid, dbo.thrxx.fno, 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, dbo.tcolor.fid AS fcolorid, dbo.tsjcs.fid AS fsjcsid, 
      dbo.tsjxh.fid AS fsjxhid, dbo.tjbpz.fid AS fjbpzid,  dbo.thrc.fmemo, dbo.thrxx.fmon,
      dbo.thyd.fid AS fhydid
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