Dennis, Two of my major applications involve Master Table Subsidiary Tables (Member master, Cur Home Address, Cur Work Adr, Contributions) The subsidary tables may or may not contain records for a given Member. Hence If i am reporting info from master,home,work tables I need to use LEFT OUTER JOINS to account for possible missing records. It would be nice to accomplish this in one view instead of a series of nested views.
I encourage users who wave requirements similar to mine to submit an enhancement request for v9.0 to include Nested OUTER JOINS. It would be nice if we could also nest INNER and OUTER JOINS. Some of my information in the above senario include coded info that I like to report as a readable value. Hence the nested INNER and OUTER joins. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Thu, 7/10/08, Dennis McGrath <[EMAIL PROTECTED]> wrote: > From: Dennis McGrath <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Re: Question > To: "RBASE-L Mailing List" <[email protected]> > Date: Thursday, July 10, 2008, 5:17 AM > 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
