update join

[Ruslan Zasukhin]

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

> 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.

We will look around about this

And I think we will try add this feature into 5.0


-- 
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]