14 Replies Latest reply: Sep 22, 2013 9:39 PM by 7d8870ae-222b-4d73-8251-86f34b1ad49e RSS

    Insert into one table by query from other table

    7d8870ae-222b-4d73-8251-86f34b1ad49e

      Dear sir, i have inserted in to Table A as below:

         ROLE_IDUSER_IDAUTH_STATBRANCH_CODE
      Teller1PhearomA001
      Teller2PhearomA001

      I want to insert the same more value for field ROLE_ID, USER_ID and AUTH_STAT, except BRANCH_CODE must change. Value of field BRANCH_CODE in can query form Table B.

      Kindly give me some idea.

      Thank and Regard.

      Phearom