Multiple database query

[gurmi]

Good afternoon one and all,

I want to write a query that will affect data across two databases (on the same server). How would I do this?

TIA for all help

Gurmi

[duncan maddox]

You can reference tables in difference databases by fully qualifying the tablename, for example

SELECT name FROM database1.dbo.table1
UNION
SELECT name FROM database2.dbo.table2

duncan

------------
gurmi at 12/4/00 6:08:30 AM


Good afternoon one and all,

I want to write a query that will affect data across two databases (on the same server). How would I do this?

TIA for all help

Gurmi