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 Received on Mon Mar 10 2003 - 11:15:42 CST