
Join two tables from seperate databases
I'd recommend using Linked Servers in SQL Server. Create a linkedserver to
the dbase4 and using fourpart naming in SQL Server to join the "tables".
SQL BOL discusses these scenarios.
HTH
--
Patrick Logan, MCSD
Opinions expressed are my own and not necessarily those of my employer.
Quote:
> Hi,
> I need to join two tables from seperate databases one from an SQL server
and
> the second a dbase IV. What is the best way to do this?
> Thanks,
> David McMullan