Re: JOIN in embedded query
| From: | leo g. divinagracia iii | Date: | Thu, 08 Aug 2002 21:30:11 +0000 |
| Subject: | Re: JOIN in embedded query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21072@lists.php.net to get a copy of this message | ||
since you didnt list what type DB you are using, i assumed MYSQL. and MYSQL
doesnt have sub SELECTs... :(
http://www.mysql.com/doc/en/UPDATE.html
the syntax lists "...WHERE where_condition..."
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 am quite certain that it is my syntax
>
>
--
Leo G. Divinagracia III
ldivinag@csuhayward.edu