Why does a query run as INNER JOIN but not on a left join? GENERIC_INTERNAL_ERROR: Unexpected identifier in logical plan: loc

Hi,

Can someone explain to me why my query works as long as I use an inner join but as soon as I change it to an Left Join I got the error: GENERIC_INTERNAL_ERROR: Unexpected identifier in logical plan: loc.

It's the table on row 38. As long as I use Inner it works.