Incorrect results might be generated when you use the Oracle access engine in a LIBNAME statement to join multiple Oracle tables and when the query contains both inner and outer joins. The results are incorrect because one of the join criteria is left out when the query is passed to Oracle.

The following example code shows a query that demonstrates this behavior:

In this case, the condition joining T3 and T3Z is not included in what is sent to Oracle to be processed. If you use the SASTRACE= option, you can see the query that is submitted to Oracle by SAS:

Select the Hot Fix tab in this note to access the hot fix for this issue.

Note: This problem does not occur in SAS^® 9.2.

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: