Can this work with "Federated Storage Engine" ?

[D Claudiu]

Hi!
I have the following structure:

Database 1 on Server 1
Database 1 - Table 1
Database 1 - Table 2 (FEDERATED)

Database 2 on Server 2
Database 2 - Table 2

Database 1.Table 2 is federated with Database 2.Table 2 on Server 2.

I need to know if the a join between Database 1.Table 1 and Database 1.Table 2 ("SELECT * FROM Database 1.Table 1 LEFT JOIN Database 1.Table 2 ON ...") will work as expected (retrieve informations from Database 1.Table 1 and from Database 2.Table 2).

Thanks!

[SOLVED]



Edited 1 time(s). Last edit at 02/01/2008 06:54AM by D Claudiu.