I’m curious if there isn’t any way to UPDATE a table field by getting the value from a joined table…
UPDATE table1 as t1 set xyz = (select xyz from table2 where ref_t1 = t1.id limit 1);
UPDATE table1 as t1 JOIN table2 as t2 on t2.ref_t1 = t1.id set xyz = t2.xyz;
do work. I assume that I have to solve this via any external (scripted) approach, is that correct?