Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008


    I am novice in Informix though I have worked in Microsoft SQL Server.
    I want to update a table from the other table in informix. How do I do this?
    For example, I can execute a query in SQL Server as

    update TableA set orderqty = b.totQty
    from TableA as a, TableB as b
    where a.shiftdate = b.shiftdate;

    Appreciate your valuable input.

  2. #2
    Join Date
    Nov 2008
    Provided Answers: 1
    This is ANSI syntax for your query:

    UPDATE TableA
    SET orderqty = (
    SELECT totQty
    FROM TableB
    WHERE TableA.shiftdate = TableB.shiftdate)


Posting Permissions

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