Fwd: Re: [PHP-DB] How to querry two db in a single statement?
| From: | markus|lervik | Date: | Fri, 04 Jan 2002 14:23:48 +0000 |
| Subject: | Fwd: Re: [PHP-DB] How to querry two db in a single statement? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15392@lists.php.net to get a copy of this message | ||
Didn't notice that this didn't get cc:d to the list, so here it hoes.
---------- Forwarded Message ----------
Subject: Re: [PHP-DB] How to querry two db in a single statement?
Date: Fri, 4 Jan 2002 15:58:35 +0200
From: markus|lervik <markus.lervik@vaasa.fi>
To: "Andy" <news.letters@gmx.de>
On Friday 04 January 2002 15:50, you wrote:
> Hi there,
>
> I would like to make a querry on 2 db. There is info in tables I would like
> to compare.
>
> As I know, there has first to be a conect on the db before the querry. But
> how to do this on 2 db??
As far as I know there aren't any relational databases that support querying
multiple databases in one query.
I guess you'd be best off querying the first database, save the result, query
the second database, save the result and then compare the two results.
Please do correct me if I'm wrong, people.
Cheers,
Markus
-------------------------------------------------------
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
markus.lervik@vaasa.fi
+358-6-325 3589 / +358-40-832 6709