Join two tables from seperate databases 
Author Message
 Join two tables from seperate databases

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



Fri, 03 Jun 2005 17:34:33 GMT  
 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



Sat, 04 Jun 2005 01:24:03 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Joining two tables from two databases

2. Table join between two tables in different databases

3. Linking tables on two seperate databases - how?

4. Joining two tables from different databases

5. Table join between two different databases (MSSQL 6.5)

6. Here's a sticky wicket - joining two tables on two diffrent servers with ADO

7. Data Entry to two seperate tables from one control simultaneously

8. Two tables, two databases

9. Linking two Access tables in two databases

10. Linking two tables from two diferent databases.

11. Creating a join on tables in two different MSSQL 6.5 DB's

12. How to Left join more than two table ?

 

 
Powered by phpBB® Forum Software