TotalEnergies interview question

Explique inner et outer join