retrieving data from multiple databases in SQL Server

hy all..
How can I achieve the above ?
Moreover can I retrieve data from multiple databases which are lying
on different DBMSs ( like retrieving from database A which is on SQL and from database B which is on Oracle ) ?
Rgds.

You need a linked server.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp

Nick

|||Linked servers are great but they can turn nasty pretty quickly, especially if you want to do updates. If possible consider gathering the data in a layer before the actual database(s) - in a SOA style.