title: How to get filtered records from Sql Server 2005?
body: <p>Consider that I have two tables.</p>
  
  <p>One is "Table1" as shown below.</p>
  
  <p><img src="https://i.stack.imgur.com/61RIU.png" alt="enter image description here"></p>
  
  <p>One more table is "Table2" as shown below.</p>
  
  <p><img src="https://i.stack.imgur.com/EupUD.png" alt="enter image description here"></p>
  
  <p>Now here what I need is, I need all the records from Table1 those ID's are not in Table2's Reference column.</p>
  
  <p>Please guide me how to do this.</p>
  
  <p>Thanks in advance.</p>