select.. where like query with 'subquery'?

I would like to create a query like this:

select table1.*, table2.*
 from table1, table2
 where table1.id=table2.id
 and table2.name like %table1.name%


so, the problem is how to put the last part with LIKE clause wich should
be 
from another table..
anybody any idea?