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