You might have joined different tables in the same database. How would it be if you could join different tables from different databases. Sounds good!! right? I had to go through an uncountable number of tutorials and blogs to make this happen. All thanks to Drupal.
There are certain conditions you have to ensure before using this method. First to make sure is that you have both databases on the same server. And the second is a fit. The second is about user, ensure both have the same.
Requirement was to get all the users in both databases.