Re: JOIN in embedded query
| From: | Michael Hendsbee | Date: | Thu, 08 Aug 2002 15:08:21 +0000 |
| Subject: | Re: JOIN in embedded query | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21063@lists.php.net to get a copy of this message | ||
You have an error in your SQL syntax near 'SELECT Emails.ID FROM Emails
RIGHT JOIN KeyWords ON Emails.ID = KeyWords.EmailsI' at line 1
"David Robley" <robleyd@paradise.net.nz> wrote in message
news:MPG.17bcd9a24f85b5c6989772@news.php.net...
> In article <20020802150555.50338.qmail@pb1.pair.com>, info@rostoplasc.com
> says...
> > 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
>
> Can you post the error?
>
> --
> David Robley
> Temporary Kiwi!
>
> Quod subigo farinam