Its not possible in innodb or myisam engine, you can do it using fedrated if i am not wrong.
regards anandkl On 8/10/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: > > Hi All, > > There are two mysql server. I need to retrive data from two different > hosts > (mysql server) and by using a join make a query. > > Is it possible to make a query which can fetch data from two different > mysql > server using join. > > -Regards, > Krishna >