title: invalid identifier in WHERE clause
body: <p>I'm trying to write the SQL to copy a row from one table to another but I keep getting an invalid identifier in the WHERE clause. I'm using oracle apex.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>INSERT INTO CRIMECLOSED (crimeClosedID, crimeName, crimeDate, crimeNotes, 
     outsideSourceDescription, dateClosed, relatedCrimes, 
     staffID, crimeTypeID, locationID)  
  SELECT CRIMEOPEN.crimeOpenID, CRIMEOPEN.crimeName, CRIMEOPEN.crimeDate, 
         CRIMEOPEN.crimeNotes,  CRIMEOPEN.outsideSourceDescription, CURDATE(), 
         CRIMEOPEN.relatedCrimes, CRIMEOPEN.staffID, CRIMEOPEN.crimeTypeID, 
         CRIMEOPEN.locationID
  FROM CRIMEOPEN
  WHERE CRIMEOPEN.crimeOpenID = '1';
  </code></pre>
  
  <p>CRIMEOPEN table</p>
  
  <pre><code>CREATE TABLE  "CRIMEOPEN" 
  (   "crimeOpenID" VARCHAR2(5), 
  "crimeName" VARCHAR2(20), 
  "crimeDate" DATE, 
  "crimeNotes" VARCHAR2(200), 
  "outsideSourceDescription" VARCHAR2(200), 
  "relatedCrimes" VARCHAR2(5), 
  "staffID" VARCHAR2(5), 
  "crimeTypeID" VARCHAR2(5), 
  "locationID" VARCHAR2(5), 
   CONSTRAINT "CRIMEOPEN_PK" PRIMARY KEY ("crimeOpenID") ENABLE
   )
  </code></pre>
  
  <p>The error I get is:</p>
  
  <blockquote>
    <p>ORA-00904: "CRIMEOPEN"."CRIMEOPENID": invalid identifier</p>
  </blockquote>
  
  <p>I think the error is trying to say that 'crimeOpenID' is not a column in 'CRIMEOPEN' but it is. 
  Any help please?</p>