Rule Definition
ANSI syntax allow a clear separation between joins clause and the where clause restrictions. The ANSI notation makes the relations between the tables explicit, and saves you from coding equality tests for join conditions in the WHERE clause. Support for full outer joins also eliminates the need for complex workarounds to do those queries (With old syntax some construction can lead to an unexpected behavior). Moreover ANSI joins allows having optimization hints.

Remediation
Check the statement and if so, replace non ANSI-Standard joins with ANSI-Standard joins.

Violation Code Sample

SELECT first_name, department_name
FROM employees, departments
where(employees.manager_id = departments.manager_id
     AND employees.department_id = departments.department_id);

Fixed Code Sample

The following example:
SELECT first_name, department_name
FROM employees, departments
where(employees.manager_id = departments.manager_id
     AND employees.department_id = departments.department_id);
should be rewritten as:
SELECT first_name, department_name
FROM employees
     JOIN departments
ON (employees.manager_id = departments.manager_id
     AND employees.department_id = departments.department_id);