Gee guys, thanks for the quick answers. Juding by the number of responses you'd think that I asked a simple question!
I'm on a 48hr development spree using MySQL for the firts time so I haven't gotten knee deep in the documentation yet. It's a great program though...fast...not bloated..simple...feature rich...no buffer overruns...What more can I say? Thanks again, David -----Original Message----- From: Gurhan Ozen <[EMAIL PROTECTED]> To: David Buerer <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Date: Wed, 13 Mar 2002 18:29:34 -0500 Subject: RE: Selecting across servers > SELECT databasename.tablename.column, databasename.tablename.column > FROM > databasename.tablename, databasename.tablename; > > > Gurhan > > > -----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
