Home

FULL OUTER JOINS should be used with caution

  • Maintainability
  • Major

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
Visual Expert 2020
 VEPLSQLRULE86