<P>我写了个这样的T_SQL语句</P> <P>select sid,subject,content,pubdate,promulgator=<BR>&nbsp;&nbsp;&nbsp;case<BR>&nbsp;&nbsp;&nbsp;&nbsp;when exists(select * from snm_scheme where did&gt;0) then (select name from&nbsp; snm_department where snm_department.did=snm_scheme.did and snm_scheme.did&gt;0) <BR>&nbsp;&nbsp;&nbsp;&nbsp;when exists(select * from snm_scheme where cid&gt;0) then (select name from snm_Center where&nbsp;&nbsp; snm_center.cid=snm_scheme.cid&nbsp;&nbsp; and snm_scheme.cid&gt;0)&nbsp;<BR>&nbsp;&nbsp;&nbsp;&nbsp;else <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(select username from snm_user where snm_user.uid=snm_scheme.uid)<BR>&nbsp;&nbsp;&nbsp;end </P> <P>from&nbsp; snm_scheme</P> <P>我想给promulgator字段筛选后都有数据填充.现在的问题是 获得的promulgator 列结果中只有满足第一个when 条件的数据填充,这是怎么回事啊?</P> <P>有没有办法能解决</P>