update sjtj set sjks=
(case tx+dj when 'cxgc_c1' then (select min(sjbh) from cxgc where bh='1'and sjbh like '1%' )
when 'cxgc_c2' then (select min(sjbh) from cxgc where bh='1'and sjbh like '2%')
when 'cxgc_c1 'then (select min(sjbh) from cxgc where bh='2 ' and sjbh like '1%')
end
)
(case tx+dj when 'cxgc_c1' then (select min(sjbh) from cxgc where bh='1'and sjbh like '1%' )
when 'cxgc_c2' then (select min(sjbh) from cxgc where bh='1'and sjbh like '2%')
when 'cxgc_c1 'then (select min(sjbh) from cxgc where bh='2 ' and sjbh like '1%')
end
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货