>>>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
>>
>>In code view you should be able to refer to the table as databasename.dbo.tablename .. ie..
>>
>>select table1.whatever, table2.morefields from
>>thislocaltable Table1 join databasename.dbo.tablename Table2 on table1.fieldX = table2.fieldY
>
>Right, this is clear enough, but it would be nice to be able to drag/drop or to be able to add a table from a different database visually.

Oh come on! That's too easy :P