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
