problems with nested correlated queries

Has anyone of you ever experienced problems with queries with multiple levels of nesting, where an (inner) subquery is correlated to an (outer) subquery which is 2 (or more) levels of nesting above it? We found that some of these queries yield an incorrect result (more precisely, a superset of the correct set of rows). We are using OnLine 6.0 under Solaris 2.3 on a Sun SparcServer 10/512. Ria. ----------------------------------------------------------- Ria Vandenberghe Ria.Vandenberghe@rug.ac.be UNIVERSITY OF GHENT (BELGIUM) - Computer Science Laboratory Technologiepark-Zwijnaarde 9, B-9052 ZWIJNAARDE, BELGIUM tel: +32/9/264.55.10 fax: +32/9/264.58.42