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.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.