LOL! My understanding is we use nested inner joins all the time! That is what we do with multi table where clauses. We just never had had the new syntax available until now.
Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Bentley Sent: Wednesday, July 09, 2008 6:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Question 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 --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
