select DISTINCT tsi.FLOT_TEXTfrom T_STK_INSTOCKENTRY tsi where EXISTS (SELECT DISTINCT TAO.FLOT_TEXT FROM T_AR_RECEIVABLEENTRY_O TAO WHERE TAO.FLOT=TSI.FLOT)AND tsi.FLOT_TEXT !=''当我加多一个字段就多了几条记录,后面想显示的字段都会增加数据。咋整select DISTINCT tsi.FLOT_TEXT,tsi.FREALQTYfrom T_STK_INSTOCKENTRY tsiwhere EXISTS (SELECT DISTINCT TAO.FLOT_TEXT FROM T_AR_RECEIVABLEENTRY_O TAO WHERE TAO.FLOT=TSI.FLOT)AND tsi.FLOT_TEXT !=''MYSQL用的比较多,SQLSERVER的groupby又得把显示的字段都得加进去,加跟没加一样,不加就会显示不包含在聚合函数内