At 05:41 PM 7/9/2008, Dennis McGrath wrote:
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
Currently, R:BASE 7.5, 7.6 and Turbo V-8 for Windows support
INNER JOINS and Nested INNER JOINS.
You may submit an enhancement request for R:BASE eXtreme (v 9.0)
at: http://www.rbase.com/rbg9rdcc
Very Best R:egards,
Razzak.
