Query is something like:

declare @p1 varchar(4), @p2 varchar(6)

set @p1 = '%ZH%'

set @p2 = '%8434%'

select * from table1 o left join table2 t on o.x=t.x

where o.canton like @p1 and o.postcode like...