Query over 2 databases

Hi,

I have 2 databases: Warehouse and Store. I want to run a query to get the Item Quantity in both databases. Both the databases are on one server.

Thanks

You can reference the database using three part naming:

Select * from Databasename.OwnerOrSchema.Objectname

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Use 'three-part' object naming (Servername.Schema.Object); something like this:

SELECT
w.ItemID,
WarehouseQuantity = w.Quantity,
StoreQuantity = s.Quantity
FROM Warehouse.dbo.MyWarehouseTable w
JOIN Store.dbo.MyStoreTable s
ON w.ItemID = s.ItemID
WHERE w.ItemID = {item I want}

Leave off the WHERE clause if you want all items.

|||

Thanks Arnie

Worked Perfect.