就是下面这个句子。。我在SQL DEVELOPER中执行是没有问题的。。 但是在.NET下面就会报 缺失表达式。。 请各位帮我解答下疑问。。 select au.zz name,count(au.qcode) ccount from ISTIC_DATA_CSTPCD_AUTHOR au inner join (select distinct(arti.AID) disaid,arti.qcode qcode from ISTIC_DATA_CSTPCD_FUND fund inner join ISTIC_DATA_CSTPCD_ARTICLE arti on fund.qcode=arti.qcode where 1=1 and fund.JJXM like '%安徽%' ) te on te.qcode=au.qcode group by au.zz order by ccount desc看看字段或者别名等，有没有是.NET关键字 学习了... 后面加个分号试试 select au.zz name,count(au.qcode) ccount from ISTIC_DATA_CSTPCD_AUTHOR au inner join (select distinct(arti.AID) disaid,arti.qcode qcode from ISTIC_DATA_CSTPCD_FUND fund inner join ISTIC_DATA_CSTPCD_ARTICLE arti on fund.qcode=arti.qcode where 1=1 and fund.JJXM like '%安徽%' ) te on te.qcode=au.qcode group b
