How to import data from Multiple servers using federated engine

[Amit Rane]

Hi all,

I wish to import data from multiple servers onto a single local machine using a federated engine.

the data is distributed on multiple servers where the database structure is same
only the table contents are different.
eg:

Server1:

table name question.

id........type
_________________
1 ........easy
2 ........medium
3 ........hard



Server2:

table name question.

id........type
_________________
4 ........easy
5 ........medium
6 ........hard


now the above two tables are on different servers.
I want to import data from both these tables using single federated table
and show the output as follows on a client machine.

Client:

table name question.

id type
________________
1 easy
2 medium
3 hard
4 easy
5 medium
6 hard


please i need it urgently.

thanx in advance

Amit.