Hitachi Energy interview question

Difference beetwen left inner join