Re: cannot do outer join with the 'like' operator

Hi,

"Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote in message news:5e66rtksgk3fbt69mmdofm9eg39ksadbea_at_4ax.com...

> Dear all,
>
> Can anyone show me how to do outer join with the 'like' operator?
>
> SQL> l
> 1 select a.fsc, b.category_code
> 2 from tb_products a, tb_category b
> 3* where a.secco_code like b.secco_prefix || '%' (+)
> SQL> /
> where a.secco_code like b.secco_prefix || '%' (+)

change to
where a.secco_code like b.secco_prefix(+) || '%'

Hth
 Thomas

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG