Código:
SELECT
contact.id,
org.name,
ctt_country.name as contact_country,
org_country.name as org_country
FROM
contact
INNER JOIN org ON (org.id=contact.org_id)
INNER JOIN country as ctt_country ON (contact.country_id=ctt_country.id)
INNER JOIN country as org_country ON (org.country_id=org_country.id)
Ahi encontre la solución!!
La clave esta en el
AS del
JOIN. No sabia que tenia tanta importancia.
Que les parece?