SQL Command not properly ended ORA-00933

[jadams0173]

Hello. I very rarely have to use Oracle to run a query and in the past they were even simpler than what I'm trying to do now.

I'm trying to query a db from VB6 and got an error. So I tried to run my query from SQL*Plus and got the following. I'm stuck, can someone give me push!! Thanks in advance!

This is from SQL*Pluse

SQL> SELECT READIT.NCDATA.SFCNUMBER, READIT.NCDATA.NCCODE, READIT.NCCODE.DESCRIPTION, READIT.NCDATA.
OPERATION, READIT.NCDATA.NCTSTAMP, READIT.NCDATA.REFDES,READIT.NCDATA.RESRCE, READIT.NCDATA.NCLOGONI
D, READIT.NCDATA.CLOSEDFLAG  
  2  FROM READIT.NCDATA 
  3  INNER JOIN READIT.NCCODE ON (READIT.NCDATA.OPERATION = READIT.NCCODE.OPERATION) 
  4  AND (READIT.NCDATA.NCCODE = READIT.NCCODE.NCCODE) 
  5  GROUP BY READIT.NCDATA.SFCNUMBER, READIT.NCDATA.NCCODE, READIT.NCCODE.DESCRIPTION, READIT.NCDAT
A.OPERATION, READIT.NCDATA.NCTSTAMP, READIT.NCDATA.REFDES, READIT.NCDATA.RESRCE, READIT.NCDATA.NCLOG
ONID, READIT.NCDATA.CLOSEDFLAG
  6  HAVING (((READIT.NCDATA.SFCNUMBER)='30289C9') AND ((READIT.NCDATA.NCCODE)<>'TE501') AND ((READI
T.NCDATA.OPERATION) Like '21%' Or (READIT.NCDATA.OPERATION) Like '22%') AND ((READIT.NCDATA.CLOSEDFL
AG)='N'));
INNER JOIN READIT.NCCODE ON (READIT.NCDATA.OPERATION = READIT.NCCODE.OPERATION)
      *
ERROR at line 3:
ORA-00933: SQL command not properly ended

I tried to have patience but it took to long! -DW

 

[jadams0173]

It just shows my lack of knowledge of Oracle. With more reading I got it to work. Didn't realize the join issues.

SELECT D.SFCNUMBER, D.NCCODE, C.DESCRIPTION, D.OPERATION, D.NCTSTAMP, D.REFDES,D.RESRCE, D.NCLOGONID, D.CLOSEDFLAG  
FROM READIT.NCDATA D, READIT.NCCODE C
WHERE (D.OPERATION = C.OPERATION) 
AND (D.NCCODE = C.NCCODE) 
GROUP BY D.SFCNUMBER, D.NCCODE, C.DESCRIPTION, D.OPERATION, D.NCTSTAMP, D.REFDES, D.RESRCE, D.NCLOGONID, D.CLOSEDFLAG
HAVING (((D.SFCNUMBER)='30289C9') AND ((D.NCCODE)<>'TE501') AND ((D.OPERATION) Like '21%' Or (D.OPERATION) Like '22%') AND ((D.CLOSEDFLAG)='N'));

I tried to have patience but it took to long! -DW