I have two tables Master and a Child. Both Master and Child table have multiple rows. I want to update multiple ROWS in Child table using one query which contains a column from Master table. In this case whether JOINT function will work, if so please provide the syntax or please suggest any other option to update the column in child table.
I guessed that all Child table rows have a corresponding row in Master table.
In other words, Child table has logically foreign key constraint to Master table
(Wheather you defined explicitly FOREIGN KEY in your table or not.)
UPDATE Child_table c
SET (col_a , col_b , ...)
= (SELECT col_x , col_y , ...
FROM Master_table m
WHERE <matching conditions>