Hi, I am a newbie to Metabase. I am trying to use a simple SQL query with 2 tables (left outer join) and trying to use a field filter in the where clause. I mapped the field filter with the database table and column. When I try to run the query it throws error saying "Unknown column in the where" complaining about the column used in the field filter. If I just use only one table without any joins then it seems working. Anyone faced anything like this and does this have a working solution?
Here is an example query that I am trying to run:
select *
from PRODUCTS p
left outer join REVIEWS r on r.product_id = p.id
where {{product_filter}}