Re: ORA-00933: SQL command not properly ended

Hello Christina,

   What version of Oracle you are using now, this inner join will work only 
Oracle 9i and later version.. and it will not work preior version like 
Oracle 8i...

  If you try the same query in Oracle 9.0.1.20 VERSION and later then, it 
will work...

  Have a good day...

Suresh





>From: "Christina Lu" <[email protected]>
>Reply-To: "Oracle" <[email protected]>
>To: "Oracle" <[email protected]>
>Subject: [oracle] Re: ORA-00933: SQL command not properly ended
>Date: Mon, 10 Mar 2003 23:27:30
>
>   Yes, I got those, but I just want to know why can I use an INNER JOIN in
>Oracle 8i?
>
>Christina
>
>
> > Try put it like this :
>
>select *
>from emp
>,       dept
>where emp.deptno = dept.deptno;
>
>
>-----Original Message-----
>From: Christina Lu <[email protected]>
>To: Oracle <[email protected]>
>Date: Monday, March 10, 2003 4:02 PM
>Subject: [oracle] ORA-00933: SQL command not properly ended
>
>
> >  Hi,
> >I got an error message when I tried to join the EMP and DEPT table by
> >using the INNER JOIN clause in Oracle SQL*Plus, and here is the simple 
>sql
> >statements:
> >
> >    select *
> >    from emp inner join dept
> >    on emp.deptno = dept.deptno;
> >
> > And this is an error message that I got:
> >
> >  ORA-00933: SQL command not properly eded
> >
> >
> >Would you tell me what should I do to fix this?
> >
> >Thanks,
> >Christina
> >---
> >Change your mail options at http://p2p.wrox.com/manager.asp or
> >to unsubscribe send a blank email to %%email.unsub%%.
> >
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or
>to unsubscribe send a blank email to %%email.unsub%%.


_________________________________________________________________
Cricket World Cup 2003- News, Views and Match Reports. 
http://server1.msn.co.in/msnspecials/worldcup03/


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].