1:  CREATE TABLE table1 (id int);
   2:  INSERT INTO table1 VALUES (1);
   3:  INSERT INTO table1 VALUES (2);
   4:  INSERT INTO table1 VALUES (3);
   5:   
   6:  CREATE TABLE table2 (id int);
   7:  INSERT INTO table2 VALUES (2);
   8:  INSERT INTO table2 VALUES (3);
   9:   
  10:  CREATE TABLE table3 (id int);
  11:  INSERT INTO table3 VALUES (2);
  12:  INSERT INTO table3 VALUES (3);
  13:   
  14:  SELECT table1.id,
  15:         table2.id,
  16:         table3.id
  17:  FROM table1
  18:    LEFT OUTER JOIN
  19:       table2
  20:    INNER JOIN
  21:       table3
  22:       ON table2.id = table3.id
  23:       ON table1.id = table2.id;
  24:   
  25:  SELECT table1.id,
  26:         table2.id,
  27:         table3.id
  28:  FROM table2
  29:    INNER JOIN
  30:       table3
  31:       ON table2.id = table3.id
  32:    RIGHT OUTER JOIN
  33:       table1
  34:       ON table2.id = table1.id;