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

Your SQL should look like this
select a.fsc, b.category_code
  from tb_products a, tb_category b
 where a.secco_code = b.secco_prefix (+)

The symbols "|| '%'" really mining less here.

Robert

"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 || '%' (+)
> *
> ERROR at line 3:
> ORA-00933: SQL command not properly ended
>
> Inner join is ok for the 'like' operator, though.
>
> Thanks,
> Dino
>
Received on Fri Sep 28 2001 - 02:08:37 CDT