An incorrect Implicit Pass-Through query is generated when you use the following code, which contains a mixture of inner and outer joins:

You might receive an error similar to the following when you use Oracle:

   ERROR: ORACLE prepare error: ORA-00904: "A"."X1": invalid identifier.
   SQL statement:  select a."X1", a."VISIT", b."X2", c."X3"
   from (select a."X1", a."VISIT", b."X2" from SQLD5A a, SQLD5B b where
   a."X1" =  b."X2" (+) and (a."VISIT" = 110) ), SQLD5C c where a."X1" =
   b."X2" (+) and (a."X1" = c."X3").

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

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 :