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 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
