Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    11

    Unanswered: update query in informix

    Hi All,

    I am trying to update a table. I am putting a calculated field in a temp table. and I am updating the other table with the new calculated field.

    I tried this syntax:

    update table A
    set A.col=B.col
    from B(temp table)
    where A.colA=B.colA

    but I am having an error.


    Thank you for your help in advance.

  2. #2
    Join Date
    Dec 2003
    Location
    North America
    Posts
    146
    try this:

    update table A
    set A.col = (select B.col
    from table B
    where A.colA=B.colA)

Posting Permissions

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