Make mysql query with INNER JOIN between different mysql servers

1

How could I query with INNER JOIN between different servers, as exemplified below:

SELECT
    serverA.clinte AS CLIENTE,
     serverB.enderecoCliente AS ENDERECO
FROM
    127.0.0.1.dbo.cliente AS serverA 
    INNER JOIN 192.168.0.1.dbo.clientes AS serverB 
    ON serverA.cli_id = serverB.cli_id
    
asked by anonymous 06.02.2018 / 12:04

0 answers