Hi all:
AFAIK, it is possible in a bunch of database software to query multiple DBs
through joining. I have a Foxpro background (so most of what I say is therefore,
b.s.) but you can define your query tables using this notation:
database.table
Which allows you to query multiple DBs.
You should be able to do this (using joins) in MySQL. However, I don't know how
off the top of my head. That might be more of a MySQL-list-geek type of question.
Cheers,
db
markus|lervik wrote:
> 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 <[EMAIL PROTECTED]>
> To: "Andy" <[EMAIL PROTECTED]>
>
> 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
> [EMAIL PROTECTED]
> +358-6-325 3589 / +358-40-832 6709
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
--
Dan Barton
Terrestrial Program Biologist
Asst. Data Manager
Point Reyes Bird Observatory
http://www.prbo.org
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
