Re: Using data in one table to update data in another table

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

Using data in one table to update data in another table

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); Here th