SELECT * FROM database1.table1 ... database2.table2 ... WHERE.... > -----Original Message----- > From: David Buerer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 6:14 PM > To: [EMAIL PROTECTED] > Subject: RE: Selecting across servers > > > How do you do it from different databases on the same server? > > 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 > > > > > > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- > 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 > >
--------------------------------------------------------------------- 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