查询不重复数据出错！(SOS......)

[shuren]

select DISTINCT a.id ,name,b_date,ename from aaa a,bbb b,ccc c where a.id=b.id and a.id=c.id and b.id=c.id
报的错是：
Server Message: Number 421, Severity 16
Server 'SYBASE', Line 1:
TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT.
在里面查加上ename 就出错它是TEXT类型！
我只想查不是重复的id的值怎么办！谢谢！

[shuren]

select a.id ,name,b_date,ename from aaa a,bbb b,ccc c where a.id=b.id and a.id=c.id and b.id=c.id group by a.id 就出来了！哈哈，谢谢楼上的！~

[hobbylu]

用可以实现 having count(*)=1