Search and update query

[MDA]

Hi all,

I need to compose a query that searchs for a "string" and updates one of the columns within the string.

Example:
TABLE: A
COL1, COL2, COL3, COL4, COL5

TABLE: B
COL1, COL2, COL3, COL4, COL5, COL55

In plain english I need to
UPDATE TABLE A and
SET A.COL5 = B.COL55
FROM A,B
WHERE A.COL1,A.COL2,A.COL3,A.COL4,A.COL5 = B.COL1,B.COL2,B.COL3,B.COL4,B.COL5


Any ideas how to do this in SQL?

Thanks in advance for any ideas.
Regards,
MDA

 

[MDXer]

this should work

UPDATE TABLE A and 
 SET A.COL5 = B.COL55  
 FROM A
      JOIN B ON A.COL1 = B.COL1
                A.COL2 = B.COL2
                A.COL3 = B.COL3
                A.COL4 = B.COL4
                A.COL5 = B.COL5

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[MDA]

Thanks Daffy...

I just made a slight change for my test and it worked great.

--------
UPDATE A
SET A.COL4 = B.COL5
FROM A JOIN B ON A.COL1 = B.COL1 AND
A.COL2 = B.COL2 AND
A.COL3 = B.COL3 AND
A.COL4 = B.COL4 AND
A.COL5 = B.COL5


--------

Thanks again for your time.
M

 

[MDXer]

D'OH I knew I forgot something

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck