title: Why does my SQL query return keyword not found
body: <p>I'm trying to retrieve all houses where there is no reservation connected to a certain &quot;huisnummer&quot; (housenumber).</p>
  <pre><code>SELECT * FROM huis WHERE NOT EXISTS(select * FROM reservering WHERE reservering.huisnummer = huis.huisnummer)
  </code></pre>
  <p>When I execute the code in my localhost phpMyAdmin I get an error:</p>
  <pre><code>Keyword does not recognize. (near &quot;not&quot; at position 25)
  Keyword does not recognize. (near &quot;EXISTS&quot; at position 29)
  Unexpected token. (near &quot;(&quot; at position 35)
  
  #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 0, 25' at line 1
  </code></pre>