AgileAssets interview question

Explain what left join and right join are in SQL