Re: does SELECT & JOIN not work?

Hello,

"Alex Savricov" <tech_at_pronto.ru> schrieb:
> I've tiped next SQL code:
> select c.class_name from classes c join roster r on c.class_id=r.class_id
>
> And have encounter next error:
> *
> ERROR at line 1:
> ORA-00933: SQL command not properly ended
>
> Why?

IMHO Oracle does not support the word "JOIN" in SQL-Statements.

Ciao, Dirk. Received on Sat Aug 12 2000 - 00:00:00 CDT