Query sql with like operator from two tables

Question

I need something like:
select * from table1 where name like %table2.name

Answer 1

u can use join between 2 tables if there is a common field

Answer 2

select <col list>
from table1 t1 inner join table2 t2
on t1.name like concat('%', t2.name, '%')