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.