In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > "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 > 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? > > > 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 Cheers -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
