Yes it's possible. See CREATE VIEW command in BOL.

>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