select jb.*,
case when #gdsbz#='G' then dzd.gsjbjxqx else dsjbjxqx end as jbjxqx,
case when #gdsbz#='G' then dzd.gsjbjxed else dsjbjxed end as jbjxed
case when #gdsbz#='G' then dzd.gsjbjxqx else dsjbjxqx end as jbjxqx,
case when #gdsbz#='G' then dzd.gsjbjxed else dsjbjxed end as jbjxed
from dkdz_jb_jbxdxx jb
参考链接:http://blog.itpub.net/26451903/viewspace-733526