Please give me a solution for joining tables from multiple DBs like I want to find the customer name who has highest number of purchase. But in Purchase DB I've the table only with Customer ID not names, address and other personal details. These personal details are in another DB. So please give me the solution for overcome this problem.
We are running into huge problem because of this, as we could not use the dashboard to find the insights.
This is just the glimpse of the problem. Please help me out.