select DISTINCT tsi.FLOT_TEXT

from 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.FREALQTY

from 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 !=''

MYSQL用的比较多，SQLSERVER的groupby又得把显示的字段都得加进去，加跟没加一样，不加就会显示不包含在聚合函数内