Report question

Question: MySQL LEFT JOIN with optional value in second table