Variable with two identical left join tables

1

Hi,
I have a sql of the form:
....
table1 t1 left join table1 t2 on ...

and I am trying to use the {{date}} variable to be linked to table1 t1 table. It seems that Metabase does not allow to use this variable if there are two identical tables in the statement. I was hoping to write something like t1.{{date}} ....Any solution?

2

Hi @ivobrabec
Currently you cannot use Field Filters with table aliases - see comments for possible workarounds:
https://github.com/metabase/metabase/issues/3324 - upvote by clicking :+1: on the first post