Results 1 to 2 of 2

Thread: update join

  1. #1
    Join Date
    Jan 2004
    Location
    singapore
    Posts
    3

    Unanswered: update join

    hi i have problems updating a field in a table with the value from another table, below is what the 2 table looks like

    wk_balances
    ---------------
    customer
    alt_ind

    wk_customer
    ----------------
    cust_id
    industry

    i want to link the 2 tables with the wk_balances.customer and wk_customer.cust_id

    then i want to replace the values of alt_ind in wk_balances with the values of industry in wk_customer

    can someone please help me out with this? Thanks alot!

    sincerly
    vps

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    update wk_balances a
    set alt_ind =
    (select industry
    from wk_customer b
    where b.cust_id = a.customer)
    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
  •