I am trying to make a view in SQL server that takes data from two diferent databases. The two tables are exaclty the same and what i need it is a union between them.

The query designer doesn't allow me to do so, so I'm wondering wether this is possible or not.

any clues