Chris Nighswonger wrote: >Hi All, > Is it possible in MySQL to use UPDATE to update fields in one table with >data from another table? For example, the following code seems to be the >answer but fails with a syntax error in MySQL: > >UPDATE test_demo1.products SET nontaxable=(SELECT IMFSalesTax FROM >IDX.InvMasFile);
Multi table update is available if you're using version 4.0.4 or higher: http://www.mysql.com/doc/en/UPDATE.html --Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
