How to use multiple LEFT JOINs in SQL

Question

Is it possible to use multiple left joins in sql query       LEFT JOIN         ab      ON         ab sht   cd sht   i want to add to attach one more query like this to it  will it work       LEFT JOIN         ab AND aa     ON         ab sht   cd sht            AND         aa sht   cc sht   Will this work

User · Answer

The required SQL will be some like -    SELECT   FROM cd LEFT JOIN ab ON ab sht   cd sht LEFT JOIN aa ON aa sht   cd sht        Hope it helps

User · Answer

Yes  but the syntax is different than what you have  SELECT      lt fields gt  FROM      lt table1 gt      LEFT JOIN  lt table2 gt          ON  lt criteria for join gt          AND  lt other criteria for join gt      LEFT JOIN  lt table3 gt           ON  lt criteria for join gt          AND  lt other criteria for join gt

User · Answer

Yes it is possible   You need one ON for each join table   LEFT JOIN ab   ON ab sht   cd sht LEFT JOIN aa   ON aa sht   cd sht   Incidentally my personal formatting preference for complex SQL is described in http   bentilly blogspot com 2011 02 sql-formatting-style html   If you re going to be writing a lot of this  it likely will help

User · Answer

You have two choices  depending on your table order  create table aa  sht int  create table cc  sht int  create table cd  sht int  create table ab  sht int   -- type 1     select   from cd inner join cc on cd sht   cc sht LEFT JOIN ab ON ab sht   cd sht LEFT JOIN aa ON aa sht   cc sht  -- type 2 select   from cc inner join cc on cd sht   cc sht LEFT JOIN ab LEFT JOIN aa ON aa sht   ab sht ON ab sht   cd sht

[sql] How to use multiple LEFT JOINs in SQL?

Examples related to sql

Examples related to join

Examples related to left-join