title: Why am I not getting any results from this SQL query (MS Access)
body: <p>I have two tables, one is a local table in Access 2010 (<strong>Employees</strong>) and the other is a linked table in a SQL Server 2014 database (<strong>dbo_Employees</strong>). The query is run inside Access.</p>
  
  <p>For reference, both tables are identical. Same columns, same data. They are literally copies of one another. The only difference is that I deleted one record from the SQL Server table. I did this because the query I'm trying to run is to find all the records in the <strong>Employees</strong> table that match records that exist in the <strong>dbo_Employees</strong> table. This should return all but the one deleted record. While it does exist in the Employees table, since it doesn't exist in the dbo_Employees table, it would be excluded in the results. Here is the query:</p>
  
  <pre><code>select Employees.ID
  from Employees
  where Employees.ID IN (SELECT dbo_Employees.ID FROM dbo_Employees)
  </code></pre>
  
  <p>When I run this, I get nothing. What am I doing wrong? </p>