请教一个很棘手的问题,如何用distinct去掉nibernate中重复的数据

[weichao0311]

Dao层中的语句是这样的:
select distinct dso.TheDataSourceCategory, from DataSourceOperator dso,DataSourceCategoryCalendar dscc,DataSourceUpload dsu where dso.TheUser.Id = ? and dso.AllowType = ? and dso.TheDataSourceCategory.TheDataSource.ActiveFlag = ? and dso.TheDataSourceCategory.TheDataCategory.ActiveFlag = ? and dso.TheDataSourceCategory=dscc.TheDataSourceCategory and dso.TheDataSourceCategory=dsu.TheDataSourceCategory and dscc.TheDataSourceCategory=dsu.TheDataSourceCategory and dsu.TheFiscalCalendar.Id='8' and dscc.TheFiscalCalendar.Id='8'group by dso.TheDataSourceCategory.Id,dso.TheDataSourceCategory.TheDataSource.Id,dso.TheDataSourceCategory.TheDataCategory.Id,dso.TheDataSourceCategory.ActiveFlag


运行时报个错:择列表中的列 'DATA_SOURCE_CATEGORY.DATA_SOURCE_ID' 无效，因为该列没有包含在聚合函数或 GROUP BY 子句

不知道哪位有什么好的方法,或者不用distinct来做