select BMXS_LSH as '学生流水号',XS_DM as '学生号',XS_XM as '姓名',XS_KH as '考号',XS_XB as '性别',CS_RQ as '出生年月',XS_MZ as '民族',ZZMM as '政治面貌', BYXX as '毕业中学',KSLB as '考生类别',WTR_DM as '委托人代码',SFZH as '身份证号',XS_DF as '生源所在地',XS_ZZ as '家庭住址',XS_YB as '邮政编码',ZY_DM as '专业代码',BJ_DM '班级代码',RXNF as '报到标志', ZXBS as '转专业标志',TZBS as '统招学生标志',ZSBS as '是否在学标志',from tbss BMXS_LSH

主:表名:tbss 主键:BMXS_LSH
请各位朋友看看我的sql语句是那里错误了

ZSBS as '是否在学标志',from tbss BMXS_LSH

最后那里多了个逗号

改为
ZSBS as '是否在学标志' from tbss BMXS_LSH

另:
select BMXS_LSH as '学生流水号',
ZSBS as '是否在学标志' from tbss BMXS_LSH

在你的选择字段和别名都有BMXS_LSH,这样会混淆

from tbss BMXS_LSH
为什么加主健?

做个试图就可以解决方便解决你的问题了。...

顺便问个问题，在from字句的后面加了主键有什么作用？

看不懂了.

谢谢了啊  "潇洒老乌龟"

呵呵，細心些！小妹妹，是太大意的緣故！關鍵詞前就多了個逗號而以

呵呵谢谢了哈

BJ_DM '班级代码'，这中间不是少了个“as” 嘛
你的意思是让'班级代码'作为新的标题名，来代替BJ_DM吗？
那这中间就应该有一个as

select BMXS_LSH as '学生流水号',XS_DM as '学生号',XS_XM as '姓名',XS_KH as '考号',XS_XB as '性别',CS_RQ as '出生年月',XS_MZ as '民族',ZZMM as '政治面貌', BYXX as '毕业中学',KSLB as '考生类别',WTR_DM as '委托人代码',SFZH as '身份证号',XS_DF as '生源所在地',XS_ZZ as '家庭住址',XS_YB as '邮政编码',ZY_DM as '专业代码',BJ_DM as '班级代码',RXNF as '报到标志', ZXBS as '转专业标志',TZBS as '统招学生标志',ZSBS as '是否在学标志',from tbss order by BMXS_LSH

少了 as
最后那个不知道你是不是想根据 BMXS_LSH 排序(可能是分组).