SELECT REGION_NAME, COUNTRY_NAME
FROM regions AS r
JOIN
countries AS c
ON c.REGION_ID=r.REGION_ID;
SELECT REGION_NAME, COUNTRY_NAME
FROM regions AS r
JOIN
countries AS c
ON c.REGION_ID=r.REGION_ID;
Add your comment