When you use a LIBNAME statement to perform an outer-join query that involves multiple SQL views against Oracle tables, it is possible that one of the outer-join criteria might be left out of the WHERE clause. For example, suppose you have a query that involves an outer join of an Oracle table and three SQL views that access other Oracle tables. When this outer join is converted from the SAS^® syntax to a former Oracle approach that uses a plus sign (+) for outer joins in the WHERE clause, only two of the three join conditions are generated in the WHERE clause. An incomplete query such as this creates a Cartesian product with incorrect results.

For example, the following query joins one Oracle table that is accessed directly and three SQL views that all reference another Oracle table:

The WHERE clause that is generated for this query should contain three conditions, as follows:

Instead, the WHERE clause contains only two conditions:

Currently, there is no solution or workaround for this problem.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: