Dennis: Did you give me an example of the syntax in your email? You made me dig more and I did find an example of a nested inner join which I assume would work the same as an outer join, but you're right. I stared it for a long time and I have a hard time understanding how to compose it!
Karen -----Original Message----- From: Dennis McGrath <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Oct 30, 2013 10:14 am Subject: [RBASE-L] - RE: Left Outer Join The is a new syntax to do multiple outer joins. Personally, I find it very hard to write, read and maintain. I prefer to use nested views to get the job done 1 view to do the first outer join 1 view using the first view as the left table in the second out join Nothing to keep you from nesting 2 or more views like this to achieve almost anything. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Wednesday, October 30, 2013 10:07 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Left Outer Join Trying something new. Can I use 2 left outer joins? Contact is my main table, may or may not be a matching ID in the Client and People table, but I'm getting a syntax error. It works fine with just t1 and t2, errors when I add in the t3 syntax: CREATE VIEW vContactAll AS SELECT t1.*, t2.*, t3.* + FROM Contact t1 + LEFT OUTER JOIN client t2 ON t1.id = t2.id + LEFT OUTER JOIN people t3 ON t1.id = t3.id Karen
