Enable the MT to use a LEFT JOIN with a INNER JOIN for same table.

bugid:109338