select a.*,tba_ygbm.ygmc,Tba_wldwbm.dwjc, (CASE WHEN a.zt=0 THEN '未审核' WHEN a.zt=1 THEN '已审核' END) AS 状态 from PRINDX a inner join Tba_wldwbm
on a.dwbm=tba_wldwbm.dwbm left join tba_ygbm on a.jsr=tba_ygbm.ygbm where a.djlx='1' order by a.rq desc
原来用 top100
但这里不知道怎么改
on a.dwbm=tba_wldwbm.dwbm left join tba_ygbm on a.jsr=tba_ygbm.ygbm where a.djlx='1' order by a.rq desc
原来用 top100
但这里不知道怎么改
on a.dwbm=tba_wldwbm.dwbm left join tba_ygbm on a.jsr=tba_ygbm.ygbm where a.djlx='1' order by a.rq desc
on a.dwbm=tba_wldwbm.dwbm left join tba_ygbm on a.jsr=tba_ygbm.ygbm where a.djlx='1' order by a.rq desc
top 100 a.*,
tba_ygbm.ygmc,
Tba_wldwbm.dwjc,
(CASE WHEN a.zt=0 THEN '未审核' WHEN a.zt=1 THEN '已审核' END) AS 状态
from
PRINDX a LEFT join Tba_wldwbm
on a.dwbm=tba_wldwbm.dwbm
left join tba_ygbm
on a.jsr=tba_ygbm.ygbm
where a.djlx='1'
order by a.rq desc
(CASE WHEN a.zt=0 THEN '未审核' WHEN a.zt=1 THEN '已审核' END) AS 状态 from PRINDX a
inner join
Tba_wldwbm
on
a.dwbm=tba_wldwbm.dwbm
left join
tba_ygbm
on
a.jsr=tba_ygbm.ygbm where a.djlx='1'
order by a.rq desc