Explain mysql left join please Explain me mysql left join behaviour please. I have simple example dataset with two tables: