>>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.
If it's not broken, fix it until it is.
My Blog