I am trying to do an UPDATE that is slightly less trivial than UPDATE persondata SET age=age+1;
What I want is something like UPDATE persondata SET age = select age from othertable where persondata.id = othertable.id; But the manual gives no clue as to whether this is possible. And if there is a decent SQL reference somewhere on the web it is not easy to find -- at least, not with the slow connection I have here in Beijing. Could someone please help? Thanks in advance, Uriel --------------------------------------------------------------------- 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