这个问题其实很简单:as重命名 只能用选择一个字段
错误的句子
SELECT (select ClassID,ClassName from P_Class where ClassID=EyeBrand) as EyeBrand1,*
FROM EyeGlass
WHERE EyeNumber = @EyeNumber
正确的
SELECT (select ClassName from P_Class where ClassID=EyeBrand) as EyeBrand1,*
FROM EyeGlass
WHERE EyeNumber = @EyeNumber