title: MySQL LEFT JOIN .. ON .. CLAUSE
body: <p>Im currently porting a MySQL db to another DBMS. I encountered the following query with the following structure.</p>
  
  <pre><code>SELECT ... FROM table1 AS tb1 
        LEFT JOIN Table2 AS tb2 
               ON tb1.x = tb2.x 
               AND tb2.y = 2 AND tb2.z = 3 ...
  </code></pre>
  
  <p>My target DBMS (DB2) "AND tb2.y = 2 AND tb2.z = 3" does not allow the following structure so i moved it to the WHERE clause. Unfortunately after moving it, the query doesn't seem to return the same rows from MySQL.</p>