17,089
社区成员
发帖
与我相关
我的任务
分享
select nwzsj_sn,dwzsj,a.swzxw,b.sxwmc from z_wzsj a,c_wzxw b where a.swzxw=b.swzxw and sbb member of (case when dwzsj>='20000101' and
dwzsj <='20050101' then str_tb('1','2') when dwzsj>='20050102' and dwzsj <='20080101' then str_tb('3','9') end);
-- JUST TRY IT ..
SELECT NWZSJ_SN, DWZSJ, A.SWZXW, B.SXWMC
FROM Z_WZSJ A, C_WZXW B
WHERE A.SWZXW = B.SWZXW
AND (SBB = (CASE WHEN DWZSJ >= '20000101' AND DWZSJ <= '20050101' THEN 1 WHEN
DWZSJ >= '20050102' AND DWZSJ <= '20080101' THEN 3 END) OR
SBB = (CASE WHEN DWZSJ >= '20000101' AND DWZSJ <= '20050101' THEN 2 WHEN
DWZSJ >= '20050102' AND DWZSJ <= '20080101' THEN 9 END));
select nwzsj_sn, dwzsj, a.swzxw, b.sxwmc
from z_wzsj a, c_wzxw b
where a.swzxw = b.swzxw
and dwzsj >= '20000101'
and dwzsj <= '20050101'
and sbb in (1, 2)
union all
select nwzsj_sn, dwzsj, a.swzxw, b.sxwmc
from z_wzsj a, c_wzxw b
where a.swzxw = b.swzxw
and dwzsj >= '20050102'
and dwzsj <= '20080101'
and sbb in (3, 9);