Re: SQL: Update .. from .. where ..

In article <3spgce$o6p_at_charon.rutgers.edu> yliang_at_charon.rutgers.edu (Yin Liang) writes:

->
->Update T1 set T1.Value = T2.Value
->From T1, T2
->where T1.Code = T2.Code (Runs perfect in SYBASE !)
->

UPDAATE T1
SET T1.Value = (SELECT Value

                FROM T2
                WHERE T2.Code = T1.Code);

--
*NOTE* address contained in header is *WRONG*. please use address below.

Witch's Bear          |You gotta program like you don't need the money,
Bill Thater           |You gotta compile like you'll never get hurt,
bill_at_cec.mc.xerox.com |You gotta run like there's nobody watching,
witchsbear_at_aol.com    |It's gotta come from the heart if you want it to work.