Hi, I have two tables on mysql: Table1: class char(10) username char(50) etc. etc.. Table2: class char(10) username char(50) time int unsigned etc.. Table2's "class" column is a new column addition and therefore does not have any values on it. I wanted to fill it up based on the "class" value found in table1. I was trying to do something like this: UPDATE table2 set class=table1.class WHERE table1.username=table2.username obviously wrong. what is the correct syntax? thanks. jaime --------------------------------------------------------------------- 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