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