What is the syntax for UPDATING the results of this select statement? I am using mySQL 3.22.27 select service.servdef from service, account, user where account.number=user.account and user.number=service.user and (service.servdef = 1) and (account.customerof = 6 or account.customerof = 7 or account.customerof = 8 or account.customerof = 9 or account.customerof = 10) There are 4860 lines that result from this select statement. I want to be able to test an UPDATE statement and make sure that it works before it is applied to the database. Sorry for the newbie question, but I am having a hard time finding a good "example" doc or text for SQL syntax. I don't know the syntax for the update. Please help. Thanks. Jeramey James [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php