multiple datasource joins

From: Date: Tue, 17 Oct 2000 20:33:38 +0000
Subject: multiple datasource joins
Groups: php.db 
Request: Send a blank email to php-db+get-3698@lists.php.net to get a copy of this message
Hi, I have been working with PHP for about 2 months and I am having some fun. However, today an interesting situation arose that I was wondering if anyone could offer a technique for this: I am wanting to do a "join" on multiple datasources (outer, inner....at this point I don't care about the type...just if it can be done). I have PHP running on an NT box because we only have database access for a proprietary db (HP turboimage) via a windows ODBC driver. PHP talks to this source fine. We also have a MySQL datasource we use. PHP obviously talks nicely to this. Now what I'd like to do is have the ability to join tables from both datasources. The only thing I can think to accomplish this is to select from one datasource, select from the other and "manually" join the data together. I am using ODBC calls for the T/I datasource and mysql calls for the MySQL (although I was thinking of making odbc calls to mysql if it would assist in the join). Any ideas?

« previous php.db (#3698) next »