title: SQL error 1064 in full outer join
body: <p>I get the error</p>
  <blockquote>
  <p>&quot;You have an error in your SQL syntax; check the manual that
  corresponds to your MySQL server version for the right syntax to use
  near 'full outer join adm_student_academic a on a.rollno=p.username
  where ps.degree='B' at line 1&quot;</p>
  </blockquote>
  <p>The query I used is as follows:</p>
  <pre><code>SELECT p.username, p.firstname, a.matric_obtain_marks
  FROM  adm_student_academic a,
        profile_student AS ps,
        PROFILE p FULL OUTER JOIN adm_student_academic a
        ON a.rollno=p.username
  WHERE ps.degree='BS(CS)' AND ps.batch = 'Fall 2010'
  ORDER BY p.username
  </code></pre>
  <p>The result I want to achieve is depicted in the following example:</p>
  <p>Suppose you have two Tables, with a single column each, and data as follows:</p>
  <blockquote>
  <p>A  : 1 2 3 4<br />
  B  : 3 4 5 6</p>
  </blockquote>
  <p>and I want the result as follows:</p>
  <blockquote>
  <p>a | 1      2  3 4 null</p>
  <p>b | null null 3 4 6</p>
  </blockquote>