Filter values in filter pane

[qliker3]

Hi,

I have two tables that i have combined with a union in sql. Lets name them table1 and table2

There are more serial numbers in table2.

In filter pane i can choose i can choose data from which table to show.

If i choose both tables the second filter in filter pane should show the serial numbers that exists in both tables (the data that does not exist in table1 should not be shown).

Is there a way to implement this?

Thanks

[anat]

if possible can you explain the scenario with sample data?