Combining SQL outer joins with inner joins
For the occasions where You really don't want to write explicit sub-queries
When You have 3 tables in an SQL query, and You need all records from table1 t1, but records from table2 t2 and table3 t3 only if there is a record on both tables t2 and t3, You have some options:
Write all outer joins with a WHERE clauses select t1.field1, t2.field2, t3.field3 from table1 t1 left outer join table2 t2 on t1.field1 = t2.field1 left outer join table3 t3 on t2.
[Read More]