I am building a view in the enterprise view designer. How do I add get a table into the view from a different database on the same server? One of the tables has a link to a table in a different database.

Thanks much
Jim