On Mon, 24 Mar 2003 15:30:45 +0100, Andreas Pflug
<Andreas(dot)Pflug(at)web(dot)de> wrote:
>Updating some rows in tab1 with corresponding values from tab2, pgsql style:
>UPDATE tab1
> SET value=T2.VALUE
> FROM tab2 T2
> WHERE T2.restr=1
> AND tab1.key=T2.key
AFAIK this should work with MSSQL7. Assuming you didn't name your
columns value and key ...
Servus
Manfred