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]

Reply via email to