In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> "David Robley" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]...
> > In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> > says...
> > > UPDATE Emails SET Sent = 'T' WHERE ID = (SELECT Emails.ID FROM Emails
> > > 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?
> 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
Indicates that the error is immediately to the left of the text given in
the error string. Which triggers my memory - from the mysql docs - this is
for ver 4, check the docs for a way of imitating sub-selects if your db
doesn't support them:
SELECT * FROM table1 WHERE id IN (SELECT id FROM table2);
You have = instead of IN
Quod subigo farinam
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php