不是了应该是这样写的 select a.ds,a.syds,b.shbbh,b.sbbh, jlfw= case b.jlfwjb when 1 then (select dq_name from wydq where dq_id=b.jlfwid) when 2 then (select wy_name from wymc where wy_id=b.jlfwid) when 3 then (select wyd_name from wyd where wyd_id=b.jlfwid) when 4 then (select yj_fl from wy_yjfl where yj_id=b.jlfwid) when 5 then (select ej_fl from wy_ejfl where ej_id=b.jlfwid) end ,sydw=(select c.zh_name from ht_base c ,ht_wyy e where c.ht_num=e.ht_num) b.azwzjb,b.azwzid from jfds_shb a join jf_shb b on a.shb_id=b.id
select a.ds,a.syds,b.shbbh,b.sbbh,
jlfw=
case b.jlfwjb
when 1 then (select dq_name from wydq where dq_id=b.jlfwid)
when 2 then (select wy_name from wymc where wy_id=b.jlfwid)
when 3 then (select wyd_name from wyd where wyd_id=b.jlfwid)
when 4 then (select yj_fl from wy_yjfl where yj_id=b.jlfwid)
when 5 then (select ej_fl from wy_ejfl where ej_id=b.jlfwid)
end ,sydw=(select c.zh_name from ht_base c ,ht_wyy e where c.ht_num=e.ht_num)
b.azwzjb,b.azwzid
from jfds_shb a join jf_shb b on a.shb_id=b.id