Hi,
Is it possible to join 2 tables using LIKE instead of “=”
I have a list of name parts and want to find all the rows in table1 where the name column contains any value from the names column in table2.
e.g.
SELECT t1.* ,t2.*
FROM table1 t1
LEFT OUTER JOIN table1 t2
ON LOWER(t1.name) LIKE CONCAT(‘%’,t2.names,‘%’)
Thanks
Gary