return columns for different sql bases

I want in one query return columns from tables where exist in different sql bases.

In MS Access can link tables from many defferents sql bases or other MSAccess bases and finally can make a simple query where return columns from tables where exist in different bases.

How can i have the same functionality in Visual Basic .Net 2005 (or Visual Basic 6.0)

If you are using SQL Server, you can use Linked servers (see http://msdn2.microsoft.com/en-us/library/ms188279.aspx) or for a one time query to another database, you can use the OPENROWSET T-SQL directly in your SQL query (see http://msdn2.microsoft.com/en-us/library/ms190312.aspx)

Regards, Uwa.

sql