Posted by scoots987 on 11/26/07 05:16

On Nov 25, 10:27 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> Assuming the <lastchanged> column belongs to table <main>, and there are no
> duplicate values for <lastchanged> per <ssn>, then the following update
> should do it:
>
> UPDATE group1
> SET address1 = c.address1,
> address2 = c.address2,
> city = c.city,
> state = c.state,
> zipcode = c.zipcode,
> country = c.country
> FROM group1 AS g
> JOIN main AS c
> ON g.ssn = c.ssn
> WHERE c.lastchanged = (SELECT MAX(c1.lastchanged)
> FROM main AS c1
> WHERE c1.ssn = c.ssn)
>
> HTH,
>
> Plamen Ratchevhttp://www.SQLStudio.com

Thank You! Worked like a charm.

• Next in forum: Re: Concat instead of SUM when grouping results
• Prev in forum: Re: Update query from another table on datechanged field
• Thread view: Re: Update query from another table on datechanged field

[Reply to this message]