Dennis, To the best of my knowledge NO! Perhaps if enough of us request this feature it will be implemented if V9.0. I have more use for nested OUTER JOINS rather than nested INNER JOINS.
Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Wed, 7/9/08, Dennis McGrath <[EMAIL PROTECTED]> wrote: > From: Dennis McGrath <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Question > To: "RBASE-L Mailing List" <[email protected]> > Date: Wednesday, July 9, 2008, 4:41 PM > Does 7.6 support nested left outer joins yet? > > SELECT + > t4.Code AS AddressType, t1.CompanyName, + ' > t2.AddressLine1, t2.AddressLine2, + > t2.City, t3.CodeAS State, t2.Zip + > FROM Contacts t1 + > LEFT OUTER JOIN Addresses t2 ON > t2.fkAddressesCustomerNumber = t1.CustomerNumber + > LEFT OUTER JOIN CodeTable t3 ON t3.CodeID = > t2.fkStateCodeID + > LEFT OUTER JOIN CodeTable t4 ON t4.CodeID = > t2.fkAddressTypeID + > WHERE t1.ParentCustomerNumber = .vCalcTarget AND + > t1.StoreNumber = .vStoreID > > Dennis McGrath
