Complex updating query, Help!!!!!

• • Reply

  13 years ago

  by RedSouljaz

  HeaVenMan

  , Indonesia

  Joined 18 years ago

  There are two tables:

   Table A                                                                   Table B

  ---------------------------------------                                        ----------------------------------------

  AID      C1       C2      Status                                     BID           col1       col2         status

  ---------------------------------------                                        ---------------------------------------------------------

  1         22         21        AA                                        1                22         21           A

  2         23         25        BB                                        2                23         21           C

  3          23         21        AA                                       3                11         44           B

   

  So here is the case,

   I want to update tableB Colom Status with condition like this:

  search colom status in table A that equal to AA, compare col C1

  and C2 in table A with colom col1 and col2 in table B. If match for example C1,C2 =
  Report abuse