"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<pan.2003.03.10.18.20.17.452819_at_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
I'm using Oracle 8i - 8.1.6... Is there any other way that can you
join 2 or 3 tables by using Oracle 8i?
Thanks,
Christina
Received on Mon Mar 10 2003 - 16:33:46 CST
