Passing Joins to MySQL

For a multiple libref join to pass to MySQL, all of these components of the LIBNAME statements must match exactly:
  • user (USER=)
  • password (PASSWORD=)
  • database DATABASE=)
  • server (SERVER=)
For more information about when and how SAS/ACCESS passes joins to the DBMS, see Passing Joins to the DBMS.