UPDATE child_table AS ct
SET ct.field1 = value1,
ct.field2 = value2
FROM ct
JOIN parent_table AS pt
ON ct.field3 = pt.field3 AND ct.field4 = pt.field4
WHERE
ct.field1 = some_val
For a better answer, provide some usefull examples with real data.
Your question is to abstract to get a good answer.
Try this:
For a better answer, provide some usefull examples with real data.
Your question is to abstract to get a good answer.