Hmm left outer join on both? I guess it should not make a difference because all will show between table1 and table2.
Thx I will give that a go… Dan Goldberg From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, March 04, 2016 2:09 PM To: Dan Goldberg Subject: [RBASE-L] - Re: SQL select join 3 tables 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 = t3id Karen -----Original Message----- From: Dan Goldberg <[email protected]<mailto:[email protected]>> To: karentellef <[email protected]<mailto:[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
