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 ended

Would anyone help me what should I do to fix this?

Thanks,
Christina Received on Mon Mar 10 2003 - 18:40:04 CET