Re: update view with composite PK

Bonjour,

try

update
t1
set t1.c3=( Select t2.c4
from
t2
where
t1.c1=t2.c1 and t2.c2=1);

Hth

Matthias Received on Fri Sep 07 2001 - 04:53:42 CDT