ado/ multiple db platforms/ on sql statement 
Author Message
 ado/ multiple db platforms/ on sql statement
Hi all,

I'm looking for a way to bring multiple data sources together in one sequel
statement.  I've done this in DAO by setting up workspaces for the different
data sources, but I'm looking for a pure ADO avenue.

For example:
SELECT p.phone, p.add1, f.account#
FROM tblPhoneList as p
INNNER JOIN tblFAccount as f
ON p.id = f.pid;

tblPhonelist would be in Access and tblFAccount in FoxPro.

Any ADO thoughts on this?

Thanks.

Kris



Sat, 30 Nov 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Multiple SQL Insert statements in a single ADO.NET Command Object call

2. One SQL Statement for Multiple Datebases - ADO / FoxPro????

3. Help: multiple select statements in SQL stored proc called by ADO

4. ADO problem with multiple SQL statements

5. ADO problem with multiple SQL statements using execute method

6. ADO problem with multiple SQL statements using execute method

7. Any DBA tools can help migrating DB changes on development platform to production platform

8. Developing SQL for multiple database platforms

9. SQL development for multiple database platforms

10. Selecting XML into an ADO Stream using multiple select statements

11. Multiple SELECT statements using ODBC & ADO

12. Transfer Db Diagrams from multiple Dbs into one Db in SQL 7


 
Powered by phpBB® Forum Software