RE: [PHP-DB] newbie dumbass question

Yes, it can, if they are on the same machine...if we are talking about different machines, I would suggest copying the tables from the first machine to the second machine (where the query is taking place). In any event, you can do something like this: <code> SELECT a.field1, b.field2 FROM db1.table1 a, db2.table2 b WHERE a.something = b.something AND ... ... ... </code> HTH Sam Masiello System Analyst Chek.Com (716) 853-1362 x289 smasiello@chekinc.com -----Original Message----- From: Adv. Systems Design [mailto:asd_2000@yahoo.com] Sent: Tuesday, August 29, 2000 9:12 AM To: PHP List Subject: [PHP-DB] newbie dumbass question I tried looking through the mysql docs, but did not find an answer...can mysql lookup (select) values from multiple databases? (as opposed to multiple tables)...I am assuming it can, but need to confirm (what would a select statement look like?). Thanks Luis __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ -- 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