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
