Hi!
I just happend to notice this old email... >>>>> "Moshe" == Moshe Gurvich <[EMAIL PROTECTED]> writes: Moshe> In MySQL 3.23, how to update one table using information from another table. Moshe> update table1 set value1=t2.value2 Moshe> from table1 as t inner join table2 as t1 using(pk_key) ??? Moshe> or Moshe> update table1 as t1 inner join table2 as t2 using(pk_key) Moshe> set t1.value1=t2.value2 ??? Moshe> Is it possible at all? This will be possible in about 4.0.3, which should be available within one month. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.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