TotalEnergies Interview Question

Explique inner et outer join