Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*plus: join operator error
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.comReceived on Mon Apr 29 2002 - 06:31:37 CDT