Chris W schrieb:
> I have the following query...
>
> SELECT c.NLCID, n.publishdate
> FROM newsletter n
> JOIN newslettersection s using (NLID)
> JOIN newslettercontent c using(NLCID)
> WHERE contenttype = 1 AND n.publishdate AND c.`timestamp` = '0000-00-00
> 00:00:00'
>
> I want to run an update on newslettercontent and set its timestamp
> column to be the publishdate from the newsletter table using the join
> rules in that query. Is there a way to do that in a query?

yes, you can, see multi-table update

http://dev.mysql.com/doc/refman/5.0/en/update.html

--
Sebastian