• No replies
228 Posts

Pinned topic How to perform distinct on a column???

‏2008-10-22T06:00:09Z |
Im currently using IDS 10.0 on a RedHat 9 server and I want to use distinct on a column and not distinctrow.

select distinct C.ID,C.NOM,T.TEL
from client C, tel_client T
where C.ID = T.ID

When I do the same query in MS access everything goes well and Ive got distinct on a column but it seems that informix does not do a distinction between distinct and distinctrow.

Thank you.