remove duplicates from sql union

Union will remove duplicates. Union All does not.

Using UNION automatically removes duplicate rows unless you specify UNION ALL: http://msdn.microsoft.com/en-us/library/ms180026(SQL.90).aspx