title: Unknown column '..' in 'field list' join
body: <p>I made a simple query with join but get always this annoying error. <br/>
  The query:<br/></p>
  
  <pre><code>SELECT 
      `verk.id`, `verk.date`, `verk.quant`, `verk.verid`, `verk.kunde`, `verk.gebracht`, `loginuser_aqa.name`, `loginuser_aqa.id`
  FROM 
      `verk` 
  FULL JOIN 
      `loginuser_aqa`
  ON
      loginuser_aqa.id = verk.verid
  WHERE
      verk.gebracht = 0
  ORDER BY  verk.date;
  </code></pre>
  
  <p><br/><br/>
  The error:<br/></p>
  
  <blockquote>
    <p><strong>Unknown column 'verk.id' in 'field list'</strong></p>
  </blockquote>
  
  <p><br/>
  Provided a demo on rextester:<br/>
  <a href="http://rextester.com/HDTJAA39589" rel="nofollow noreferrer">http://rextester.com/HDTJAA39589</a><br/><br/>
  I already tried to leave "<code>verk</code>" from <code>verk.id</code> away, but then i get another error:<br/></p>
  
  <blockquote>
    <p>id is ambiguous..</p>
  </blockquote>