I tried this and it is working well. I use 2 DB namely db1 and db2
Mysql>use db1; Mysql>select vv.visitorname,aa.visitorname from db1.visitordetails vv, db2.visitordetails aa; -Murugesan ----- Original Message ----- From: "Marek Kilimajer" <[EMAIL PROTECTED]> To: "Aris Santillan" <[EMAIL PROTECTED]> Cc: "Php (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 4:29 PM Subject: Re: [PHP] multiple db query > For MySQL Version 3.23.25 and above - yes, and it is (surprisingly) > called MERGE. I'm not sure if tables can be merged across databases. > More in the manual. > > Aris Santillan wrote: > > > is it possible to query on 2 databases > > but with same tablename and merge its output? > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
