Unable to use joins in Metabase

I am trying to do a simple join in Metabase but I keep on getting this error -

And yes, I did try aliasing the table names but that didn’t work either. I am not sure why?!

Hi,
the only thing that comes in mind is that when I use joins my syntax looks slightly different:

SELECT *
FROM bi_donation_values d
LEFT JOIN bi_project_values p on p.identifier = d.receiver_identifier

So I don´t use “as” for the left join.
But that might be just another way of expressing it.
Anyway, for me left joins work so maybe for you too!