mysql – Update table 1 taking the value from table 2


I want to update Table 1 by taking the value from Table 2. Both tables have Emp No, which is a key. I want to update the Salary column in Table 1 with the value that is present in Table 2

UPDATE TEST.tbl1 - <first the table to be updated
JOIN TEST.tbl2
IN tbl1.IDNo = tbl2.IDNo
SET Salary = Salary (from the second table)

When I tried this iam getting an Error … It says Error on or before the TRIAL ..

Please someone help me