ORA-00933: SQL-command not ended properly

From: <marpe1974_at_yahoo.se>
Date: 27 Apr 2006 07:51:59 -0700
Message-ID: <1146149519.153825.308900@e56g2000cwe.googlegroups.com>

Hi All,

I can't get this sql to work properly. I would like to update the FSA.RESOURCESTRING with FSA.ART_DATA.ID || "-" || FSA.ART_DATA.ISSUE based on the criteria below.

UPDATE FSA.ACCESSLOG
SET FSA.RESOURCESTRING = FSA.ART_DATA.ID || "-" || FSA.ART_DATA.ISSUE FROM FSA.ACCESSLOG, FSA.ART_DATA
WHERE
SUBSTR(FSA.ACCESSLOG.RESOURCESTRING,1,INSTR(FSA.ACCESSLOG.RESOURCESTRING , "-", -1)-1) = FSA.ART_DATA.DESIGNAT
AND
SUBSTR(FSA.ACCESSLOG.RESOURCESTRING,INSTR(FSA.ACCESSLOG.RESOURCESTRING , "-")+1) = FSA.ART_DATA.ISSUE; Regards,
Martin Received on Thu Apr 27 2006 - 09:51:59 CDT