Re: Re: JOIN in embedded query
| From: | Gerd Busker | Date: | Thu, 08 Aug 2002 07:01:10 +0000 |
| Subject: | Re: Re: JOIN in embedded query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21061@lists.php.net to get a copy of this message | ||
On Thu, Aug 01, 2002 at 05:57:01PM -0400, Michael Hendsbee wrote:
> UPDATE Emails SET Sent = 'T' WHERE ID = (SELECT Emails.ID FROM Emails RIGHT
> JOIN KeyWords ON Emails.ID = KeyWords.EmailsID) LIMIT 250
>
> I am getting an error, and I know it's an error in my syntax.
Shouldn't it be "WHERE ID IN (SELECT....)" instead of equals?
Also the LIMIT should probably be inside the brackets if you
want to just do 250 updates (I think).
GJ.