At 15:13 -0800 3/13/02, David Buerer wrote: >How do you do it from different databases on the same server?
Qualify your table names with the database name. SELECT db1.tbl1.*, db2.tbl2.* FROM db1.tbl1, db2.tbl2 WHERE ... If db1 or db2 happen to be the current database, you don't need to qualify references to its tables. > >David Buerer >Senior Designer >PLA Designs, Inc. > > >-----Original Message----- >From: Ken Menzel [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, March 13, 2002 1:21 PM >To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >Subject: Re: Selecting across servers > >Nope; two databases on the same server OK, but not different >servers. >Ken >----- Original Message ----- >From: "Cal Evans" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, March 13, 2002 4:00 PM >Subject: Selecting across servers > > >> >> Is it possible to issue 1 select that gathers data from databases on >2 >> separate servers? >> >> =C= >> * >> * Cal Evans >> * Journeyman Programmer >> * Techno-Mage >> * http://www.calevans.com >> * > > sql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
