Problem Note 20126: SAS/ACCESS® software now provides full support of the INNER JOIN syntax
 |  |  |  |  |
In SAS/ACCESS® software, performance can suffer when you use a mix of inner and outer joins.
In the past, Implicit Pass-Through did not support the INNER JOIN syntax. Therefore an inner join was always textualized as a comma-separated list of tables.
While this was fine when a statement specified inner joins only, it created a problem when inner and outer joins were part of the same SQL code. The order of the columns on each side of the ON clause for the outer join did not reflect the order of the tables on each side of the OUTER JOIN keywords.
SAS now offers full support for the INNER JOIN syntax, thereby fixing the problem.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| z/OS | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Linux on Itanium | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Tru64 UNIX | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#020126A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#020126| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> SQL SAS Reference ==> Procedures ==> SQL |
| Date Modified: | 2008-02-21 13:09:32 |
| Date Created: | 2007-05-02 11:44:00 |