Is it possible to write join query between multiple databases across different servers?
Is it possible?
The answer to your question is, Yes it is possible.
But since you have not specified any particular situation you are facing,it is not possible to give a direct answer.
In MySQL it can be done using The FEDERATED Storage Engine.
However I suggest you go through following SO questions