select * from table1 where exists (select 1 from table2 where table1.columA like '%' || table2.columB || '%')