How would I select distinct records from the same table on two different databases? I have two different databases that both contain a table with the same structure. I have to go across and select the distinct records across both, how is this best achieved? The uniqueness is based on Id. The other columns in the table could have varying data, but Id should be used as the basis of the distinct.

Structure is:

[Media_One].[dbo].[Video]
[Media_Two].[dbo].[Video]
SELECT DISTINCT col1, col2, ...
FROM
(
  SELECT col1, col2, ... FROM Media_One.dbo.Video
  UNION ALL
  SELECT col1, col2, ... FROM Media_Two.dbo.Video
) AS x;