Join on 3 tables

thierrydollar · #1 (**permalink**) 10-10-09, 09:46

I would like to make a LEFT JOIN between table t1 and
the result of a JOIN between t2 and t3.

mathematically, I would write
t1 LEFT JOIN ( t2 JOIN t3)

In SQL, I only know how to make
t1 LEFT JOIN t2 ... LEFT JOIN t3
or
t1 LEFT JOIN t2 ... JOIN t3

But this doesn't give me the expected result.
How could I do this
t1 LEFT JOIN ( t2 JOIN t3)

Thanks for your help

gvee · #2 (**permalink**) 10-10-09, 09:55

Code:

SELECT *
FROM   t1
 LEFT
  JOIN (
        SELECT *
        FROM   t2
         INNER
          JOIN t3
            ON t3.field2 = t2.field2
       ) As an_alias
    ON an_alias.field1 = t1.field1

thierrydollar · #3 (**permalink**) 10-10-09, 10:28

Thanks George. This works fine.

Internet Services

Web Development

Digital Marketing

Consumer Tech