Hitachi Energy Interview Question

Difference beetwen left inner join