The ORA-00907 Error Appears When Running a Report

When using an Oracle 9.2 data source, under certain circumstances, multiple or nested join operations may fail and produce the following error.

ORA-00907: missing right parenthesis

A query that uses both a left outer join and an ON clause condition returns zero values instead of null values.