Re: Fwd: Re: [PHP-DB] How to querry two db in a single statement?

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 <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 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- ---------- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org dbarton@prbo.org dbarton@grayflycatcher.org