I have a table with a date value that I need to update with a value from
another table.
The table I want to update is profile. The profile table is linked to
the study table with the foreign key StudyID.
the profile table has the date I want to update to the value in the date
value in the
On Fri, May 22, 2009 at 1:22 PM, Chris W 4rfv...@cox.net wrote:
Of course study to profile is a one to many relationship. How do I run an
update to set p.`Date` equal to s.`Date`?
This is covered in the docs for UPDATE. Read that and come back if
you're stuck.
- Perrin
--
MySQL General