Re: ORA-00933: SQL command not properly ended

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 11 Mar 2003 05:20:19 +1100
Message-Id: <pan.2003.03.10.18.20.17.452819@yahoo.com.au>

On Mon, 10 Mar 2003 09:15:42 +0000, Christina wrote:

> 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

What version of Oracle are you using?? The inner join syntax only became possible with 9i. And what you've written works just fine in 9iR2:

SQL> select * from emp inner join dept on emp.deptno=dept.deptno;

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO     DEPTNO DNAME          LOC
---------- ---------- --------- ---------- --------- ---------- ---------- ---------- ---------- -------------- -------------      7369 SMITH      CLERK           7902 17-DEC-80        800                    20         20 RESEARCH       DALLAS
      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30         30 SALES          CHICAGO

(With apologies for the wrapping).

Regards
HJR Received on Mon Mar 10 2003 - 12:20:19 CST