title: Database error - RIGHT and FULL OUTER JOINs are not currently supported
body: <p>I was trying to RIGHT JOIN two tables using this query </p>
  
  <pre><code>SELECT Persons.firstname, company.lastname
  FROM Persons
  RIGHT JOIN company ON Persons.firstname=company.firstname;
  </code></pre>
  
  <p>which comes with this error-</p>
  
  <blockquote>
    <p>RIGHT and FULL OUTER JOINs are not currently supported </p>
  </blockquote>
  
  <p>How can we get rid of this ?</p>
  
  <p>Note: I am using Mozilla DB manager. </p>