use subquery in select statement oninit.com oninit provides unrivalled technical expertise to the global informix database community. promoting product adoption through customer satisfaction Category:programming and developer software Global Rank:2,759,893 visits:15.0K pages/Per:1.6 ADS