Jump to content

iznubadd

New Members
 View Profile  See their activity

  • Posts

    1

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

iznubadd's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. iznubadd
    hi i have a table READING_METER with fields READ_METER, PREVIOUS_READ and CU. what i would like to do is update the value of CU field using (READ_METER - PREVIOUS_READ) query: UPDATE READING_METER SET CU = SUM(READ_METER - PREVIOUS_READ) when i run this i get an error on this: "An aggregate may not appear in the set list of an UPDATE statement." Please help.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.