Correlated Subquries

Posted in 1996

Cosmo Lee — Wed, 06 Nov 1996 19:15:10 -0800 — source: Informix-list mailing list archive (1991-1998)

Can anyone suggest a good source for understanding Correlated Subqueries? I've been reading the "Informix Guide to SQL: Tutorial V7.1". Specifically, on page 3-36 is a subquery that I can't seem to de-construct satisfactorially in a way that makes sense to me. The manual doesn't do much to actually explain in detail how these subqueries work. Subqueries have always been a sticky thing for me. Sometimes I understand what is happening, but at other times I look at something and I have no idea how it moves from point A to point B. Any suggestions appreciated - Thanks.