Rule description

• FULL OUTER JOINS should be used with caution

Non-compliant Code Example

SELECT emp.first_name,
	emp.last_name,
	dept.department_id,
	dept.department_name
FROM employees emp 
FULL OUTER JOIN departments dept ON (emp.department_id = dept.department_id); --Non compliant code