>Hi, > I'd like to retrieve data which contain in 2 db. How could I do? > db1->table-in-db1->field-in-table-in-db1 > db2->table-in-db2->field-in-table-in-db2 > I'd not extract data to new table because I'd like to >retrieve data only. Refer to the tables by qualifying them with the name of the appropriate database, for example, as db1.table or db2.table. This will work as long as the tables are in databases hosted by the same server. > >thanks >SF -- Paul DuBois, [EMAIL PROTECTED] --------------------------------------------------------------------- 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