I was sent e-mail to ask about update SQL, but the mailing list return this to me. Why? SF At 09:58 7/6/2001 +0000, you wrote: >Your message cannot be posted because it appears to be either spam or >simply off topic to our filter. To bypass the filter you must include >one of the following words in your message: > >database,sql,query > >If you just reply to this message, and include the entire text of it in the >reply, your reply will go through. However, you should >first review the text of the message to make sure it has something to do >with MySQL. You have written the following: > > >Dear, > I known that we can not use update table from another table > (update table1 >set table1.field = table2.field). Someone suggestion use select to temp >table before update. I wonder how to do this and how data in temp table go >update in true table. > >Regards, >Sommai Fongnamthip --------------------------------------------------------------------- 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