Yes, I got those, but I just want to know why can I use an INNER JOIN in
Oracle 8i?
Christina
> Try put it like this :
select *
from emp
, dept
where emp.deptno = dept.deptno;
-----Original Message-----
From: Christina Lu <huonglu@xxxxxxxxxxx>
To: Oracle <oracle@xxxxxxxxxxxx>
Date: Monday, March 10, 2003 4:02 PM
Subject: [oracle] 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
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or
>to unsubscribe send a blank email to %%email.unsub%%.
>
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to leave-oracle-1796914O@xxxxxxxxxxxxx
|
