help with update sql
From: Whocares <reply_at_the_group.com>
Date: Tue, 19 Aug 2003 17:17:48 +0200
Message-ID: <Tir0b.15135$os2.215309_at_news2.e.nsc.no>
Date: Tue, 19 Aug 2003 17:17:48 +0200
Message-ID: <Tir0b.15135$os2.215309_at_news2.e.nsc.no>
Hi,
I think it should be an easy sql but I'm stuck and I could use some help
here ...
Table:
U1 U2 Ref Gro
I want to update the U1 and U2 columns where Ref>1 with the values from the
row where Ref=1 but grouped by Gro - eg wanted result:
U1 U2 Ref Gro
TIA,
1 1 1 1
2 2 2 1
1 1 3 1
a a 1 2
b c 2 2
c a 3 2
1 1 1 1
1 1 2 1
1 1 3 1
a a 1 2
a a 2 2
a a 3 2
Zsolt
Received on Tue Aug 19 2003 - 17:17:48 CEST