Re: Extremely very complex SQL query with outer's

Posted in 1998

Mario R. Canto — Wed, 04 Feb 1998 09:22:00 -0300 — source: Informix-list mailing list archive (1991-1998)

It's not complex at all. Only looks strange. The parenthesis means the application of outer clause to the inmediate external table. For example in: > FROM p1, outer ( menuln p2, outer ( menuln p3, > outer ( menuln p4, outer ( menuln p5 ) ) ) ) "outer ( menuln p3,..." its outer for menuln p2. If you don't put parenthesis, each outer is for p1, only. Hope this helps Byte byte! Mario R. canto mcanto@intec.unl.edu.ar http://www.intec.unl.edu.ar/~mcanto Ian Clark wrote: > > Hi All, > > I'm not sure how easy this question is to answer but here goes. > > I am perusing some code that has the following statement: > > SELECT some_stuff> > FROM p1, outer ( menuln p2, outer ( menuln p3, > outer ( menuln p4, outer ( menuln p5 ) ) ) ) > > WHERE some_conditions > > For goodness sake...what's with all the outer's? :-) > > Cheers, Ian. > > Tedious 'office speak' part 3: "Let's go scuba in the think tank