1 2 Previous Next 18 Replies Latest reply: Jun 29, 2006 9:52 AM by 516988 RSS

    update statements from 2 diff tables

    516988
      I run the following query in Sybase that updates cha3 based on the where clause from the 2 tables cha3, act:

      update cha3
      set CHAACTNO=CHAACTNO+ACTCD
      FROM CHA3, ACT
      WHERE CHAACTNO = ACTNO
      and chabrnno=actbrnno
      and chaprdno=actprdno

      how can this run in plsql?

      theodora
        1 2 Previous Next