SQLserver查询语句重命名时，列名的别名无效

原来的语句：

select distinct WTDH,DWMC,GCMC,ZH,SGBW,MEMO,SYXM,QYR,QYRZS,JZDW,JZR,JZRZS,SYSL AS SYBH,WTDW,GCMC,SGBW,TYZL,SJYQ,JCCS,QYR,QYRZSH,JZDW,JZR,JZRZSH,SYSL FROM HTMIS.dbo.GL_XCSYWTD WHERE WTDH='TG0500001S';

修改为：

select xc.WTDH SYBH,xc.DWMC WTDW,xc.GCMC,xc.ZH SGBW,xc.SGBW TYZL,xc.MEMO SJYQ,xc.SYXM JCCS,xc.QYR,xc.QYRZS QYRZSH,xc.JZDW,xc.JZR,xc.JZRZS JZRZSH,xc.SYSL FROM GL_XCSYWTD xc WHERE xc.WTDH='TG0500001S';

至于为啥。。就很迷啊。。。
另外如果是要省略表名前面的HTMIS.dbo的话，需要在左上方修改为HTMIS