Re: ORA-00933: SQL command not properly ended

  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 protected].