[RBASE-L] - Question

[Dennis McGrath]

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