Report question

Question: How can I substitute a left join in SQL