title: SQL DELETE From with sub query syntax error
body: <p><br>
  I am having difficulty runing SQL code in MS Access 2010. I would like to ask for help in reviewing and correcting it.</p>
  
  <p><strong>Data:</strong> <br>
  - two tables with names: <code>Tbl_001_WholeBase</code> and <code>Tbl_002_NewKVG</code> <br>
  - they have connected by column named <code>Key</code></p>
  
  <p><strong>Problem:</strong> <br>
  I want to delete all rows from <code>Tbl_001_WholeBase</code> which have <code>Key</code> that is not available in table <code>Tbl_002_NewKVG</code></p>
  
  <p><strong>Example:</strong> <br> <br>
      <strong>Tbl_001_WholeBase</strong></p>
  
  <pre><code>ID Key
  1  Hronic1
  2  Hronic2
  3  Hronic3
  </code></pre>
  
  <p><strong>Tbl_002_NewKVG</strong></p>
  
  <pre><code>ID Key 
  1  Hronic1 
  2  Hronic2 
  </code></pre>
  
  <p>So as a result I would like to leave in <code>Tbl_001_WholeBase</code> only 3rd record, base would look like this: </p>
  
  <pre><code>ID Key
  3  Hronic3  
  </code></pre>
  
  <p><strong>What I wanted to use in Access was:</strong> </p>
  
  <pre><code>DELETE 
  FROM Tbl_001_WholeBase 
  WHERE Tbl_001_WholeBase.KEY IN 
  (SELECT * 
  FROM Tbl_001_WholeBase 
  LEFT JOIN Tbl_002_NewKVG 
  ON Tbl_001_WholeBase.Key = Tbl_002_NewKVG.Key 
  WHERE (((Tbl_002_NewKVG.Key) Is Null)));
  </code></pre>
  
  <p><br>
  The subquery is working properly, however I can't connect it with Delete statement.
  <br>
  <br>
  <strong>Error I got when running this code is:</strong></p>
  
  <blockquote>
    <p>You have written a subquery that can return more than one field without using the Exists reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.</p>
  </blockquote>