title: Find missing values on the same column of two tables
body: <p>Suppose you have two tables in a SQL Server database with the same schema for both tables.  I want to compare a single column on both tables and find the values that are missing in table1 but are in table2.  I've been doing this manually in Excel with a macro after I've gotten a distinct list in each query, but it would be less work if I had a query.  How can I find the missing records via T-SQL?  I'd like to do this for the following data types: <code>datetime, nvarchar &amp; bigint</code>.</p>
  
  <pre><code>SELECT DISTINCT [dbo].[table1].[column1]
  FROM [dbo].[table1]
  ORDER BY [dbo].[table1].[column1] DESC
  
  SELECT DISTINCT [dbo].[table2].[column1]
  FROM [dbo].[table2]
  ORDER BY [dbo].[table2].[column1] DESC
  </code></pre>