?? 查詢代理領貨后沒有退貨沒有銷售的手機.sql
字號:
declare @gtid char(4)
declare @act int
declare @Val char(16)
if @act=3
SELECT a.*, gl.fid AS fglid, gt.fid AS fgtid, gt.fna AS fgtna, gt.ftel AS fgttel,gl.fdate as fgtlhdate,gl.fmemo as fglmemo,gl.fmon as fglmon,gt.fper as fgtuser
FROM dbo.vAllSj a INNER JOIN
dbo.tgtlh gl ON a.fid = gl.fhrxx INNER JOIN
dbo.tgt gt ON gl.fgt = gt.fid
WHERE (gl.fhrxx NOT IN
(SELECT fcode
FROM thxc)) AND (gl.fid NOT IN
(SELECT fgl
FROM tgtth)) and gt.fid=@gtid
if @act=1--按型號查找
SELECT a.*, gl.fid AS fglid, gt.fid AS fgtid, gt.fna AS fgtna, gt.ftel AS fgttel,gl.fdate as fgtlhdate,gl.fmemo as fglmemo,gl.fmon as fglmon,gt.fper as fgtuser
FROM dbo.vAllSj a INNER JOIN
dbo.tgtlh gl ON a.fid = gl.fhrxx INNER JOIN
dbo.tgt gt ON gl.fgt = gt.fid
WHERE (gl.fhrxx NOT IN
(SELECT fcode
FROM thxc)) AND (gl.fid NOT IN
(SELECT fgl
FROM tgtth)) and gt.fid=@gtid and a.fsjxhid=@val
if @act=2--按串號查找
SELECT a.*, gl.fid AS fglid, gt.fid AS fgtid, gt.fna AS fgtna, gt.ftel AS fgttel,gl.fdate as fgtlhdate,gl.fmemo as fglmemo,gl.fmon as fglmon,gt.fper as fgtuser
FROM dbo.vAllSj a INNER JOIN
dbo.tgtlh gl ON a.fid = gl.fhrxx INNER JOIN
dbo.tgt gt ON gl.fgt = gt.fid
WHERE (gl.fhrxx NOT IN
(SELECT fcode
FROM thxc)) AND (gl.fid NOT IN
(SELECT fgl
FROM tgtth)) and gt.fid=@gtid and a.fno=@val
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -