Paul I did not see Jim's response on 12/1. I may have deleted it by accident. Could you restate it. I tried James' response below and it does not seem to work. I need to experiment with it some more. thanks.
From: [email protected] To: [email protected] Subject: [RBASE-L] - Re: Multiple Joins Date: Mon, 8 Dec 2014 15:18:39 -0500 Bill, Did you see Jim’s response from 12/1 and did it not work? Paul Buckley From: [email protected] [mailto:[email protected]] On Behalf Of James Bentley Sent: Monday, December 01, 2014 6:21 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Multiple Joins TRY: SELECT + j1.col1,t3.col3 FROM ((table1 t1 LEFT OUTER JOIN + table2 t2 ON t1.col1 = t2.col1) J1 LEFT OUTER JOIN t3 ON J1.col1 + = t3.col1) NOTE addition of parenthesis and the addition of the J1 to indicate the first join that is connected to the second join. I had to eliminate the T2.Col1 value since it is the same as the T1.Col1 and since the entire first join isindicated by J1 I could not find the method of specifying the common column for the two tables. Jim Bentley, American Celiac Society 1-504-737-3293 From: BILL MILYARD <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, December 1, 2014 12:00 PM Subject: [RBASE-L] - Multiple Joins I've been unable to create multiple joins. Does RBase allow multiple joins as: SELECT t1.col1,t2.col1,t3.col3 FROM table1 t1 LEFT OUTER JOIN table2 t2 ON t1.col1 = t2.col1 LEFT OUTER JOIN t3 ON t1.col1 = t3.col1 ?
