I've never had to do one myself, but I've saved this old example of the syntax
in case I ever do:
CREATE VIEW vContactAll AS SELECT id, company, plname +
FROM (Contact t1
LEFT OUTER JOIN client t2 ON t1.id = t2.id) J1 +
LEFT OUTER JOIN people t3 ON J1.id = t3.id
Karen
-----Original Message-----
From: Dan Goldberg <[email protected]>
To: karentellef <[email protected]>
Sent: Fri, Mar 4, 2016 3:51 pm
Subject: [RBASE-L] - SQL select join 3 tables
I am needing SQL guru help on joining three tables in a select statement.
I have table1, table2, table3
Table1 and table2 are joined by a common column. Then I need to join Table3 to
those using an outer join. That way all the rows from Table1 and Table2 will
show and only some of the matching data from Table3.
I can inner join table1 and table2 but not sure on how to left outer join table
three to table2.
TIA
Dan Goldberg
