I have table A with the following fields:
ID | ID_PAIS_ENVIO | ID_PAIS_RECIBO
1 | 23 | 47
//...
I have table B with the following fields:
ID | NOME_PAIS
23 | Brasil
47 | Portugal
//...
I need a query that returns the following result:
ID | ID_PAIS_ENVIO | NOME_PAIS_ENVIO | ID_PAIS_RECIBO | NOME_PAIS_RECIBO
1 | 23 | Brasil | 47 | Portugal
Is it possible to get the above result without doing INNER JOIN 2 times in the same query?