Re: does SELECT & JOIN not work?

"Alex Savricov" <tech_at_pronto.ru> writes:

> 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?

Try something like this instead:

select c.class_name from classes c, roster r where c.class_id=r.class_id;

-- 
Prasanth Kumar
kumar1_at_home.com