James,
This is so sad. What more do you have to live for? |-) Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of James Bentley Sent: Monday, April 19, 2010 16:56 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: JOIN or INTERSECT and Temporary Tables Please note you heard it first on this list! Undocumented hidden gem in RBase v7.6 for Win and v7.6 for Dos and v9.02 &64 bit). RBase supports NESTED INNER JOINS, NESTED OUTER JOINS, and NESTED INNER AND OUTER JOINS. Here is the syntax I have been using since I discovered it early last week. SELECT columnList FROM (( tablename1 T1 + LEFT OUTER JOIN tablename2 T2 ON T1.keyfield=T2.keyfield) J1 + LEFT OUTER JOIN tablename3 T3 ON J1.keyfield=T3.keyfield) J2 + INNER JOIN tablename4 T4 ON J2.keyfield=T4.keyfield You can mix any sequence of LEFT/FULL/RIGHT OUTER JOIN and INNER JOIN The key to a successful use of the nesting is to make sure you have the correct sequence of parens. Remember a JOIN involves only TWO tables one on each side of the JOIN keywords. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 _____ From: "[email protected]" <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, April 19, 2010 2:07:39 PM Subject: [RBASE-L] - JOIN or INTERSECT and Temporary Tables Hi, I have two temporary tables with a common column, SEQ#. Is there any way to create a third TEMPORARY table doing an INNER JOIN or an INTERSECT? I use this third temporary table to display a ListView on a form. Is one method (INNER JOIN vs INTERSECT) better than the other? There is a one to many relationship between the two temporary tables, if that makes a difference. Thank you in a advance, Diane DeMers [email protected] DeKalb, IL
