Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*plus: join operator error

SQL*plus: join operator error

From: Sted Alana <Sted_Alana_at_hotmail.com>
Date: Mon, 29 Apr 2002 11:31:37 GMT
Message-ID: <3ccd2f2d_1@news.iprimus.com.au>


I cannot get this query to work with the join operator. I get the error below. I believe it has something to do with my syntax.

Any help appreciated.

SQL> select dname
  2 from emp e join dept d on e.deptno = d.deptno   3 group by dname
  4 having sal > 4000;

from emp e join dept d on e.deptno = d.deptno

           *
ERROR at line 2:
ORA-00933: SQL command not properly ended

--
N e w s N e t  C u s t o m e r
E - m a i l :  sted.alana_at_hotmail.com
Received on Mon Apr 29 2002 - 06:31:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US