title: How can isolve Mysql Error: Code: 1064
body: <p>I tried to run the following query to select all of the lines respecting the join criteria, then adds all the rows in the table "client" and the table "commande" that were rejected because they did not meet the join criteria.</p>
  
  <p><strong>Query</strong>:<code>SELECT * FROM CLIENT c  FULL JOIN  commande com  ON c.id_client=com.id_client</code></p>
  
  <p><strong>Error</strong>:Error Code: 1064
  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 JOIN  commande com  on c.<code>id_client</code>=com.<code>id_client</code>
   LIMIT 0, 1000' at line 1</p>