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!