mmmmmm...una cosa di questo tipo dovrebbe andare:
codice:
SELECT cpc.id, cpc.country
FROM catalog_purchases_countries AS cpc
INNER JOIN catalog_shipments_types AS cst ON cst.country = cpc.country
INNER JOIN catalog_payments_types AS cpt ON cpt.country = cpc.country