I'm using version 5.?.
Excellent. That seemed to do the trick.
Thanks,
Jesse
- Original Message -
From: "Remo Tex" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 05, 2006 2:31 AM
Subject: Re: UPDATE Based on Relation
Jesse wrote:
I need to be able to do
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 >=
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'
