Re: UPDATE Based on Relation

Jesse wrote: I need to be able to do an UPDATE based on a relation. The following code works in Microsoft SQL. What is the MySQL Equivalent? UPDATE Chapters SET MatSentDate='2006-07-04' FROM Invoices I JOIN Chapters C ON C.ID=I.ChapterID JOIN Schools S ON S.ID=C.SchoolID WHERE I.InvoiceDate

Re: UPDATE Based on Relation

I'm using version 5.?. Excellent. That seemed to do the trick. Thanks, Jesse - Original Message - From: Remo Tex [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, July 05, 2006 2:31 AM Subject: Re: UPDATE Based on Relation Jesse wrote: I need to be able to do an UPDATE

UPDATE Based on Relation

I need to be able to do an UPDATE based on a relation. The following code works in Microsoft SQL. What is the MySQL Equivalent? UPDATE Chapters SET MatSentDate='2006-07-04' FROM Invoices I JOIN Chapters C ON C.ID=I.ChapterID JOIN Schools S ON S.ID=C.SchoolID WHERE I.InvoiceDate = '2006-01-06