Joining two tables from different databases

[Dean Perry]

I have a table from a SQL Server database and a table from a Foxpro
database loaded into a dataset. There is a one-to-one relationship
between the tables although there may not be a record in the SQL table.
I would like to display the Foxpro data in a datagrid and mark the row
if there is a matching record in the SQL table.

Any ideas?

 

[Mary Chipman [MSFT]]

I'd write a stored procedure in SQL Server that returns the rows.
Whenever you're performing heterogeneous joins you have to pull in all
of the rows for both tables. This will likely go faster if you do it
on the server.

--Mary