471,083 Members | 1,192 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

help with update sql

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
1 1 1 1
2 2 2 1
1 1 3 1
a a 1 2
b c 2 2
c a 3 2

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
1 1 1 1
1 1 2 1
1 1 3 1
a a 1 2
a a 2 2
a a 3 2
TIA,
Zsolt
Jul 19 '05 #1
0 2547

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Randy Harris | last post: by
6 posts views Thread by Takeadoe | last post: by
9 posts views Thread by SAL | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.