Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    32

    Unanswered: Need Immediate Help on UPDATE SQL

    Hi
    This is on UDB 8.01.005

    I want to know how could I convert this sybase query into UDB

    UPDATE TABLE A
    SET B.price = A.PRICE
    FROM
    TABLE A, TABLE B
    Where
    A.no = B.no And
    A.dt = B.dt

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Try this (but I have not tested it):

    UPDATE TABLE A
    SET A.Price =
    ( SELECT B.Price
    FROM TABLE B
    WHERE A.no = B.no
    AND A.dt = B.dt )
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •