From: Perrin Harkins
Date: May 22 2009 7:08pm
Subject: Re: Update with value form another table
List-Archive: http://lists.mysql.com/mysql/217655
Message-Id: <66887a3d0905221208s3e24f123ga937b1b5d09ea9c8@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Fri, May 22, 2009 at 1:22 PM, Chris W <4rfvgy7@stripped> wrote:
> Of course study to profile is a one to many relationship. =A0How do I run=
 an
> update to set =A0p.`Date` equal to s.`Date`?

This is covered in the docs for UPDATE.  Read that and come back if
you're stuck.

- Perrin