1 Replies - 4112 Views - Last Post: 03 May 2011 - 12:58 PM

#1 TechDee  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 70
  • Joined: 21-May 10

ORA-00971: missing SET keyword -- My syntax is correct

Posted 03 May 2011 - 12:28 PM

I receive this error below. The syntax is correct. I uses the oracle 10g.

SQL> UPDATE PRODMASTER, PRODSALES
  2  SET PRODMASTER.PROD_QOH = PROD_QOH - PS_QTY
  3  WHERE PRODMASTER.PROD_ID = PRODSALES.PROD_ID;
UPDATE PRODMASTER, PRODSALES
                 *
ERROR at line 1:
ORA-00971: missing SET keyword



Is This A Good Question/Topic? 0
  • +

Replies To: ORA-00971: missing SET keyword -- My syntax is correct

#2 baavgai  Icon User is offline

  • Dreaming Coder
  • member icon

Reputation: 5800
  • View blog
  • Posts: 12,635
  • Joined: 16-October 07

Re: ORA-00971: missing SET keyword -- My syntax is correct

Posted 03 May 2011 - 12:58 PM

UPDATE only supports a single table. You probably have to use two sub queries here.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1