I get the error The table 'table name' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause. when running a report. How do I fix this?

Document ID : KB000055642
Last Modified Date : 14/02/2018
Show Technical Document Details

This error is telling you that the outer-join syntax that you are using is not TRANSACT SQL. By default Reporter uses TRANSACT SQL to build queries. This is the *= syntax for the outer join. If the query contains the syntax "LEFT OUTER JOIN", this is ANSI SQL and Reporter does not recognize this without setting the DBMS value in the registry for the DbmsListForSql92OuterJoin setting. This setting is located under:
HKEY_CURRENT_USER\Software\Computer Associates\IQObject.ini\QueryGeneration\
This setting takes a comma separated list of DBMS names. The DBMS name can be found in an ODBC trace. For example, SQL Server's DBMS name is Microsoft SQL Server.