SELECT *
      FROM a
 LEFT JOIN (b