title: How to use Inner Join in MS Access with column name with space
body: <p>I  have two table <strong>Business</strong> and <strong>Territory</strong> where Business.Territory maps to Territory."Territory ID". When I am trying to join these tables, I am getting error "<strong>Invalid use of '.','!', or '()' in query expression</strong>" . I am using below query:</p>
  
  <pre><code>select * from
      Business INNER JOIN Territory
      ON Business.Territory = Territory."Territory ID"
  </code></pre>
  
  <p>When I remove double quotes and replace with square brackets ([]), it asks for parameter value in pop-up. Please note "Territory ID" is as it is (with space).</p>
  
  <p>How can I join these tables. Any help would be appreciated. Thanks in advance. </p>