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.

UPDATE TABLE_B B
SET B.PLANT  = CASE
WHEN (B.CODE IN (SELECT CODE  FROM TABLE_A A))
THEN A.PLANT 
ELSE NULL
END;

Table 1

| code | plant | 
|:---- |:-----:|  
| A001 | 30009 |  
| B001 | 30018 | 
| C001 | 30006 | 

Table 2

| DATE        | CODE | PLANT |
|:------------|:----:|:-----:|
| 2024-09-03  | A001 |       |
| 2024-09-03  | B001 |       |
| 2024-09-03  | C001 |       |
| 2024-09-04  | A001 |       |
| 2024-09-04  | C001 |       |
| 2024-09-05  | A001 |       |
| 2024-09-06  | B001 |       |
| 2024-09-06  | A001 |       |
| 2024-09-06  | C001 |       |