查看手机的所有详细信息.sql

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

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