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

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.