Although the SQL Procedure Pass-Through Facility has always passed joins to the DBMS, it is now possible to pass joins to the DBMS without using Pass-Through. Beginning in Version 7, the LIBNAME ...

INNER JOIN (Used to exemplify equi-join) An equi-join is one type of INNER JOIN that can be applied using SQL. Equi-joins will be used with SELECT statements to select data from more than one table.