Hi, I just realized that mysql does not have nested queries, and I need to do something like this: update table1 set A="blah" where B=(select B from table1, table2 where table1.B=table2.B) Is it possible? Thanks, Jeff Pavel [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