title: sql outer join shows the error in mysql workbench
body: <p>I have two tables <code>country</code> and <code>state</code>:</p>
  
  <pre><code>country
  -----------
  cid
  countrycode
  countryname
  
  state
  -------
  sid
  cid (fk)
  statecode
  statename
  </code></pre>
  
  <p>I am writing a join as: </p>
  
  <pre><code>SELECT s.sid, 
         s.statename, 
         c.countryname 
  FROM   state s, 
         country c 
  WHERE  s.cid = (+) c.cid 
         AND c.id = 1 
  </code></pre>
  
  <p>The above query gives a syntax error. Does MySQL not accept '+' symbol?    </p>