update join

[Ruslan Zasukhin]

On 3/2/12 10:02 PM, "George Parkinson" <george at microtherapy.ca> wrote:

Hi George, 

> hi ruslan,
> 
> i believe the mysql syntax would be:
> 
> UPDATE t1 
> INNER JOIN t2 ON t1.id = t2.id
> SET t1.f1 = t2.f1
> 
> and the sqlserver version would be:
> 
> UPDATE t1 
> SET t1.f1 = t2.f1
> FROM t1 
> INNER JOIN t2 ON t1.id = t2.id
> 
> i can't see this being used often, but i will need to use it when
> transitioning clients to valentina.
> each client (dozens) will have a minimum of 500k records needing this...and
> yes, it's 1:1.

Btw,

What sense in this transformation for Valentina ?

You try convert this into RecID - ObjectPtr link?
Or else?


Note, we have command COPY LINKS,
Intended to transform any link to any link.




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]