Posted by ZeldorBlat on 11/01/05 18:46

Try this:

update A, (select B.b1, max(B.b2) b2
from B
group by B.b1
) as x
set A.a2 = x.b2
where A.a1 = x.b1

• Next in forum: MySql permission problems (Win 2000)
• Prev in forum: Re: Using development system before uploading to web
• Thread view: Re: Multiple update question

[Reply to this message]