很奇怪的问题，急求解！！在线等

[AppaleInTheCollapsar]

语句A
SELECT * FROM (SELECT GWEN_TA_File_Snd.* , (SELECT COUNT(1) FROM GWEN_TA_File_Snd_Upload WHERE (fileid = GWEN_TA_File_Snd.id)) AS dzcount ,
(GWEN_TA_File_Snd.copies-ISNULL((SELECT tomecopies + ruincopies + sendcopies + encycopies + lendcopies FROM GWEN_TA_File_Env_Trans
WHERE (fileid = GWEN_TA_File_Snd.id)), 0)) AS holdcopies FROM GWEN_TA_File_Snd ) ASDF WHERE (1=1)
AND (LEFT(envlsh,4)=YEAR(GETDATE())) ORDER BY envlsh DESC
语句B
select * from (select * from GWEN_TA_File_Snd)

语句A去掉（(SELECT COUNT(1) FROM GWEN_TA_File_Snd_Upload WHERE (fileid = GWEN_TA_File_Snd.id)) AS dzcount）或（(GWEN_TA_File_Snd.copies-ISNULL((SELECT tomecopies + ruincopies + sendcopies + encycopies + lendcopies FROM GWEN_TA_File_Env_Trans
WHERE (fileid = GWEN_TA_File_Snd.id)), 0)) AS holdcopies FROM GWEN_TA_File_Snd ) ASDF）这两句的任何一句语句A执行都没问题。如果以上两句都去除则语句A无法执行

因此我很不明白语句A和语句B看似一样，为什么A能执行而B不能？

请各位大虾指点！！！

[-狙击手-]

因此我很不明白语句A和语句B看似一样，为什么A能执行而B不能？ 

select * from (select * from GWEN_TA_File_Snd) a

[AppaleInTheCollapsar]

原来如此,谢谢了

[zccmy22]

不能select * 吧。select 字段名。再试一下，而且只能是个，要是多个我也不知会不会好用。