Trouble with SQL join on update statement-Collection of common programming errors

Having a bad time figuring out what is wrong with my update statement. Been a couple of years since I wrote any scripts. Can anybody tell me what I am doing wrong? Select Statement work fine. SELECT DESCRIPTION from maximo.inventory join maximo.item on inventory.itemnum = item.itemnum WHERE MAXIMO.ITEM.ITEMNUM=MAXIMO.INVENTORY.ITEMNUM AND

(MAXIMO.INVENTORY.MANUFACTURER=’UNKNOWN’ OR MAXIMO.INVENTORY.MANUFACTURER IS NULL) AND

INSTR(UPPER(MAXIMO.ITEM.DESCRIPTION),’OMRON’) > 0; Yet there is something wrong in the update statement that I cannot see although I know it should be easy to find. HELP!! update maximo.inventory set maximo.inventory.manufacturer=’OMRON’ from maximo.inventory join maximo.item on maximo.inventory.itemnum = maximo.item.itemnum WHERE MAXIMO.ITEM.ITEMNUM=MAXIMO.INVENTORY.ITEMNUM AND

(MAXIMO.INVENTORY.MANUFACTURER=’UNKNOWN’ OR MAXIMO.INVENTORY.MANUFACTURER IS NULL) AND

INSTR(UPPER(MAXIMO.ITEM.DESCRIPTION),’OMRON’) > 0; Error starting at line 8 in command: update inventory set manufacturer=’OMRON’ from maximo.inventory left outer join maximo.item on maximo.inventory.itemnum=maximo.item.itemnum WHERE MAXIMO.ITEM.ITEMNUM=MAXIMO.INVENTORY.ITEMNUM AND

(MAXIMO.INVENTORY.MANUFACTURER=’UNKNOWN’ OR MAXIMO.INVENTORY.MANUFACTURER IS NULL) AND

INSTR(UPPER(MAXIMO.ITEM.DESCRIPTION),’OMRON’) > 0 Error at Command Line:9 Column:24 Error report: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 – “SQL command not properly ended” *Cause: *Action: Line 9 Column 24 is at the end of this statement

set manufacturer=’OMRON’

Originally posted 2013-11-10 00:15:55.