bydefault our selection of listbox work on union. if you want to work on intersection then must be used And mode option.
simply load your table in script with Distinct keyword.
then right clik on the field1 and in general check the And mode option the select o and1 then your common field are selected in field2.
And mode.qvw 146.0 K