?? 根據(jù)串號(hào)得手機(jī)信息.sql
字號(hào):
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?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -