i need to update a row of a table taking the values of a "select ... from table1, table2 where table1.row=table2.row group by row" query. say: desc source_table; key int(10) FK column_source timestamp desc table_to_update; key int(10) column_to_update datetime i want the result of: select s.key1,max(s.column_source) from source_table s, column_to_update c where s.key=c.key group by key; to be the values in a query something like (please ignore the syntax ... just trying to explain what i need to do): update table_to_update set table_to_update.column_to_update=source_table.column_source where table_to_update.key=source_table.key awwww ... im not good in explaining ... hope u get what i wanted to say. tnxs in advance. __________________________________ www.edsamail.com --------------------------------------------------------------------- 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
