Force MySQL to use a specific key to JOIN table

SELECT
   table1.id,
   table2.id
 FROM
   table1
 LEFT OUTER JOIN
   table2
   FORCE INDEX FOR JOIN (table1_id)
   ON (table2.table1_id = table1.id)

Reference: https://stackoverflow.com/a/1272402