RE: Wrong Results from Select on sysindexes Subquery

David properly shamed me for not including IDS Version and OS Version. I tested 9.40.FC4 on Solaris 8 and AIX 5L. I also tested 9.40.TC6 on Windows 2000 Server. OS is irrelevant, therefore, to reproduction. In my defence - and it is a feeble one - I did say that sysindexes is a view, so that eliminates IDS 7.3 and earlier. Otherwise, I can only beg for mercy on the grounds that it is the end of the year and I am trying to keep this little beauty from disrupting my holiday plans (specifically, I plan not to rewrite all my code which uses subqueries in views). In remorse, I will happily offer the presidency of the KCIUG Steering Committee to the first sucker^wnoble volunteer willing to take on this grave responsibility. Sincerely, Christopher Coleman Steering Committee President Kansas City Informix Users Group www.iiug.org/kciug Database Analyst Pharmacy Division Mediware Information Systems, Inc. sending to informix-list