title: MSAccess Insert with sub select wont work
body: <p>I have simple query, but when I'm trying to execute this query I'm getting error:</p>
  
  <blockquote>
    <p>Query input must contain at least one table or query. (Error 3067) </p>
  </blockquote>
  
  <p>Query:</p>
  
  <pre><code>INSERT INTO FV_Ko ( FvId, OldPriceNetto )
  SELECT [PFvId], (SELECT FV.PriceNetto1 FROM FV WHERE FV.FVnr = '123');
  </code></pre>