Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: Multiple row update ina table from another table

    Hi,

    I have the foll schema.

    table1:
    *P,A,B,C

    table2:
    *P,A,B,C

    Consider the records in the table:
    table1:
    P A B C
    1 x y n
    2 x y n
    3 x y n
    4 p q y
    5 p q n

    table2:
    P A B C
    1 x y y
    2 p q y

    i need to update the field C in table1 with the filed C in table 2
    where table1.A = table2.A and table1.B = table2.B.

    the foll query is not working.
    update table1 t1
    set c=
    (select t2.c
    from table2 t2
    where t1.A = t2.A
    and t1.B = t2.B
    )
    where exists
    (select t2.c
    from table2 t2
    where t1.A = t2.A
    and t1.B = t2.B
    )


    pls help me

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Can you describe "not working" in more detail? Based on the test data that you've posted, there is nothing for the query to do, but it should do nothing quite nicely.

    If you change the values of table1.c to 'X' or something like that, then re-run your query, it should put you right back where you started.

    -PatP

Posting Permissions

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