Help on Update query

From: evil0ne <dlehrner_at_gmail.com>
Date: Tue, 22 Jan 2008 15:45:29 -0800 (PST)
Message-ID: <8d518fe5-fc73-4752-bf05-13682905be45@v67g2000hse.googlegroups.com>

I need to move 490 records from a column named TRACKID to PS_NAME. After I do that I need to also set STATUS_CD to "RETIRED" and insert NULL values where the TRACKID used to be. I have succesfully found the 490 records with the following select statement:

SELECT

  MASTER_INVENTORY."TRACKID",
  MASTER_INVENTORY."MODEL",
  MASTER_INVENTORY."STATUSCD",
  MASTER_INVENTORY."PS_NAME"

FROM
  "SHIPWARE"."MASTER_INVENTORY" MASTER_INVENTORY WHERE
  MASTER_INVENTORY."STATUSCD" IS NULL AND   MASTER_INVENTORY."TRACKID" != 'N/A' and I have been trying to make the following work based off of the example located at http://www.psoug.org/reference/update.html:

UPDATE MASTER_INVENTORY
SET (MASTER_INVENTORY."PS_NAME",MASTER_INVENTORY."TRACKID") = (    SELECT (MASTER_INVENTORY."PS_NAME",MASTER_INVENTORY."TRACKID")    FROM "SHIPWARE"."MASTER_INVENTORY" MASTER_INVENTORY) WHERE MASTER_INVENTORY."STATUSCD" IS NULL AND   MASTER_INVENTORY."TRACKID" != 'N/A'; Thanks for all the help. Received on Tue Jan 22 2008 - 17:45:29 CST