根据串号得手机信息.sql

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

declare @fno char(16)
set @fno='8888888888888888
'
select  ltrim(rtrim(tsjcs.fna))+ltrim(rtrim(tsjxh.fmodel)) as fsjxh,tjbpz.fname,tcolor.fcolor,thrxx.fno
from thrc,tsjcs,tsjxh,tjbpz,thrxx,tcolor
where thrc.fid in(select  top 1 fhrcid from thrxx where thrxx.fno=@fno)
	and tsjcs.fid=tsjxh.fsjcs and thrc.fsjxh=tsjxh.fid
	and tjbpz.fid=thrc.fjbpz
	and thrxx.fhrcid=thrc.fid
	and thrxx.fcolor=tcolor.fid and thrxx.fno=@fno