Update field from field in linked table

[Ruslan Zasukhin]

On 11/21/06 1:22 AM, "Pierre Rossel" <prossel2 at myrealbox.com> wrote:

Hi Pierre, 

> I would like to do something like that:
> 
> UPDATE t2 
> SET t2.X = t1.X 
> FROM table1 t1 inner join table2 t2 on t1.A = t2.A
> 
> In English: 
> 
> Copy values from one table to another where field A matches.
> 
> Tried in Vstudio, but it doesn't seem that Valentina SQL support the FROM in
> an UPDATE statement.

Where you have see such syntax ??
 
> Any other idea to avoid copying values one at a time ?

I will ask Ivan.

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