Look at Bruce Chitea's post. I is the clearest display of this that I have seen. If you study it, I think the light will come on for you.
From: [email protected] [mailto:[email protected]] On Behalf Of BILL MILYARD Sent: Friday, December 12, 2014 9:37 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Multiple Joins 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]<mailto:[email protected]> To: [email protected]<mailto:[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]> [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 is indicated 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]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[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 ?
