I wish to join two database tables with mysql. Here is my scenario.
I have a mysql server at 192.168.55.5 with schema sales and table name order.
I have another mysql server at 192.168.43.44 with schema personnel and table name customer.
I wish to use a join query to see which customer has what orders.
How can I accomplish this in MySQL? Thanks