SQL & PL/SQL

hi all,


been trying to get the results from a join between two tables where one column is like another one.

table1 (nameA) examples: black2, green1

table2 (nameB) example: black2.location.uk.com, green1.location.uk.com

so for example I want to match all those in table1 with black2 to the column in table2 that begins with black2 and so on if you see what im trying to get at!

my sql so far:

select * from  schema.table1 a
join schema.table2 b 
on a.nameA like concat('%', b.nameB, '%'); 

but it errors:

ORA-00909: invalid number of arguments
00909. 00000 - "invalid number of arguments"

Any help or advice would be greatly appreciated, thankyou!