Like with the results of a subquery (multiple values) What I'm trying to do is the following concept:

SELECT field1,field2,field3 
FROM table1 
where field3 like '%'+(SELECT distinct field from table2)+'%'


But this is not allowed because like does not accept multiple values. How can I rewrite this query so I can wildcard match a field with multiple result values from another table?
Rewrite it into a JOIN

SELECT t1.field1, t1.field2, t1.field3 
FROM
    table1 t1
    JOIN
    (SELECT distinct field AS fieldx from table2) t2 
    ON t1.field3 like CONCAT('%',fieldx,'%')