I have 2 tables, Table 1 is a master which has code and respective plants. Table 2 has some data where I have the same code in Master(table 1) and I have to update the respective plants in Table 2. I tried below update statement which is not working. Please help me to update.