Hi list: How can I update a table field from a another table field, the multitable update is not implemented or yes?. I am thinking in use a foreign key (references) or tmp table or can I use table aliases? something like this:
replace into table master( fielda, fieldb , fieldc) select t1.fielda, t1.fieldb, t2.fieldx from master as t1 left join t2 on t1.fielda=t2.fielda; Any suggestion Thanks in advance. -- Tomas Carmen R. TCC S.A. telef.:+51-1-4428842 fax : +51-1-4426434 --------------------------------------------------------------------- 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
