Filter dropdown with sql and variable(2)

I union two table and two variables for filter.
Because I want to get dropdown boxes , I choose 'Field Filter'

In picture1,if i don't use union,only one table,it's not have problem
But when I union two tables,it has error,I think it's reason is "Filter to map to" right?
when I choose map to first table's column,then second table has error

So 'Field Filter' can't accpet two same variables,only one,like picture3,right?

Does it have way to solve it?

Hi @summer02905
Field Filter is referencing the table and column you have set in the sidebar.
Your second select-clause is referencing a different table.
You need to create a view on your database.

1 Like

@flamber thanks for help