title: RIGHT OUTER JOIN in SQLAlchemy
body: <p>I have two tables <code>beard</code> and <code>moustache</code> defined below:</p>
  
  <pre><code>+--------+---------+------------+-------------+
  | person | beardID | beardStyle | beardLength |
  +--------+---------+------------+-------------+
  
  +--------+-------------+----------------+
  | person | moustacheID | moustacheStyle |
  +--------+-------------+----------------+
  </code></pre>
  
  <p>I have created a SQL Query in PostgreSQL which will combine these two tables and generate following result:</p>
  
  <pre><code>+--------+---------+------------+-------------+-------------+----------------+
  | person | beardID | beardStyle | beardLength | moustacheID | moustacheStyle |
  +--------+---------+------------+-------------+-------------+----------------+
  | bob    | 1       | rasputin   | 1           |             |                |
  +--------+---------+------------+-------------+-------------+----------------+
  | bob    | 2       | samson     | 12          |             |                |
  +--------+---------+------------+-------------+-------------+----------------+
  | bob    |         |            |             | 1           | fu manchu      |
  +--------+---------+------------+-------------+-------------+----------------+
  </code></pre>
  
  <p><strong>Query:</strong></p>
  
  <pre><code>SELECT * FROM beards LEFT OUTER JOIN mustaches ON (false) WHERE  person = "bob"
  UNION ALL
  SELECT * FROM beards b RIGHT OUTER JOIN mustaches ON (false) WHERE  person = "bob"
  </code></pre>
  
  <p>However I can not create SQLAlchemy representation of it. I tried several ways from implementing <code>from_statement</code> to <code>outerjoin</code> but none of them really worked. Can anyone help me with it?</p>