ORA-00933: SQL command not properly ended

"Christina Lu" <[email protected]> Mon, 10 Mar 2003 15:13:46

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-905702-2003.03.10-14.56.16--gcdod-oracle#[email protected]>

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