Hi,

I'm trying to write a SELECT query (in Oracle) that mimics a join of two tables. However, instead of matching values exactly, it looks for values of one table that are substrings of another table's column's values.

Basically, I envision the query to have the following form:

SELECT a.name1, b.name2
FROM a, b
WHERE name1 like %name2%

The problem is that the '%' symbols cause Oracle to throw an error.

If you know of another way of writing such a query, please let me know!

Thanks in advance,
Yariv

Not sure if you know the substring sections but you could do something like:

thanks!

select *
from
tableA a
INNER JOIN
tableB b ON
a.name LIKE '%'||b.name||'%';