title: right join even if row on second table does not exist
body: <p>I want to join two tables even if there is no match on the second one. </p>
  
  <p>table user:</p>
  
  <pre><code>uid | name
  1     dude1
  2     dude2
  </code></pre>
  
  <p>table account:</p>
  
  <pre><code>uid | accountid | name
  1     1           account1
  </code></pre>
  
  <p>table i want:</p>
  
  <pre><code>uid  | username | accountname
  1      dude1      account1
  2      dude2      NULL
  </code></pre>
  
  <p>the query i'm trying with:</p>
  
  <pre><code>SELECT user.uid as uid, user.name as username, account.name as accountname
  FROM user RIGHT JOIN account ON user.uid=accout.uid
  </code></pre>
  
  <p>what i'm getting:</p>
  
  <pre><code>uid  | username | accountname
  1      dude1      account1
  </code></pre>