wangxu wrote: > How does the federated engine table work when the query statement include > a join substatement, it joins a local table with innodb engine and a > federated table. How does the server deal with the query substatement like > this?
Have you taken a gander at the documentation? http://dev.mysql.com/doc/refman/5.0/en/federated-description.html http://www.oreillynet.com/pub/a/databases/2006/08/10/mysql-federated-tables.html hope this helps -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]