title: SELECT * WHERE NOT EXISTS
body: <p>I think I'm going down the right path with this one... Please bear with me as my SQL isn't the greatest</p>
  
  <p>I'm trying to query a database to select everything from one table where certain cells don't exist in another. That much doesn't make a lot of sense but I'm hoping this piece of code will</p>
  
  <pre><code>SELECT * from employees WHERE NOT EXISTS (SELECT name FROM eotm_dyn)
  </code></pre>
  
  <p>So basically I have one table with a list of employees and their details. Then another table with some other details, including their name. Where there name is not in the eotm_dyn table, meaning there is no entry for them, I would like to see exactly who they are, or in other words, see what exactly is missing.</p>
  
  <p>The above query returns nothing, but I know there are 20ish names missing so I've obviously not gotten it right.</p>
  
  <p>Can anyone help?</p>