Outer Join Mysql

outer-join-mysql.sql

SELECT 
	u.nombre,
	ine.departamento,
	ine.provincia,
	ine.distrito 
FROM mod_ubigeo_departamento AS u
LEFT JOIN ubigeo_inei AS ine ON UPPER(u.nombre) = UPPER(ine.departamento)
WHERE ine.departamento IS NULL
GROUP BY u.nombre
UNION
SELECT 
	u.nombre,
	ine.departamento,
	ine.provincia,
	ine.distrito 
FROM mod_ubigeo_departamento AS u
RIGHT JOIN ubigeo_inei AS ine ON UPPER(u.nombre) = UPPER(ine.departamento)
WHERE u.nombre IS NULL
GROUP BY u.nombre;