>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

Reply via email to