Outer join on like

[frasernm]

Hi,

Is it possible to do an outer join using a like condition?
How about , for example, on (a.a like b.a or a.a like b.c)?

Thanks in advance,

Fraser

 

[ilev]

Hi Fraser!

What about my exaple?

select ename
from emp,dept
where emp.ename like substr(dept.loc,1,1)||'%';