[RBASE-L] - Re: nested outer joins

[Lawrence Lustig]

<<
Can someone repost the syntax for nested outer joins?
>>

SELECT t1And2.ColFromT1, t1And2.ColFromT2, t3.ColFromT3
   FROM (Table1 t1 LEFT OUTER JOIN Table2 t2 ON t1.ID = t2.ID) T1And2 
      LEFT OUTER JOIN Table3 t3 ON T1AndT2.OtherID = T3.OtherID


The trick is that each JOIN receives it's own ALIAS after the JOIN and that 
internal ALIASes are "hidden" by the new one.  In this example, the ALIASes t1 
and t2 are "hidden" by the JOINed ALIAS T1And2.

--
Larry