Thanks Eric

the databases are on the same server and so DBname.ownder.TableName syntax works.

Pete

>Are these 2 databases on the same server?
>
>If yes, you can simply use DBName.Owner.TableName syntax.
>
>If not:
>-You can link your servers.
>-You can use the OpenRowset TSQL command to retreive data from another source.
>
>
>>Hi,
>>
>>I am developing an application in VB .Net using SQL Server for the database. I have multiple databases in SQL server and have a requirement to create a recordset in VB that takes data from 2 tables in different databases.
>>
>>Is there a way to create a view that combines tables from 2 databases? Or do I need to create a recordset in memory and then populate it from both tables seperately?
>>
>>Pete