Update a thousand rows with specific value

[MrMob]

I would like to update thousand of Rows with its specific value

Suppose i have a table XYZ and ABC
XYZ contains Code,Name,RegDa te And ABC also Contains the same
but the Value of RegDate of XYZ is Different than that of ABC..
i want to update XYZ's RegDate Value From the value of RegDate of table ABC
at once...

update XYZ set RegDate=

[ck9663]

How are the two tables related? What's the key that link them together?

Happy Coding!!!

~~ CK

[Delerna]

One of the simplest ways is
[code=sql]
UPDATE xyx
set datereg=
(
select datereg from abc
where abc.Code=xyz.co de
and abc.name=xyz.Na me
)
[/code]

but as ck says, you don't indicate which fields are the key

[OraMaster]

Small modification in the posted SQL

UPDATE xyx
set datereg=
(
select datereg from abc
where abc.Code=xyz.co de
and abc.name=xyz.Na me
and abc.datereg <> xyz.datereg
)

[ck9663]

Yet another version :)

UPDATE x
set datereg = a.datereg
from XYZ x
INNER JOIN ABC a on x.code = a.code and a.name = x.name and x.datereg <> a.datereg

Happy Coding!!!

~~ CK

[raveengo]

Update a set a.regdate=b.reg date from xyz a,abc b
where a.code=b.code and a.name=b.name and a.regdate<>b.re gdate