Using data in one table to update data in another table

[Chris Nighswonger]

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 the data from the field IMFSalesTax in table InvMasFile, database IDX,
is being used to update the field nontaxable in table products, database
test_demo1.
 
Any suggestions/workarounds will be greatly appriciated.
 
 

Chris