尝试

    select tab2.*   -- whatever
      from t1 tab1
inner join t2 tab2 on ( ';'||tab2.col2||';' like '%;'||tab1.col1||';%' )
         ;

附加的;字符用于避免联接条件中的析取.

the extra affixed ; characters serve to avoid disjunctions in the join condition.