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 ...

MySQL 4 and any version of MySQL over the MyISAM storage engine are missing some basic SQL standard transactional capability. They should not be used for serious DBMS applications.