UPDATE from joined table

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?

Hi @Jurgen_Zornig,

I don’t think this is possible yet. Might I suggest, that you open a feature request at https://github.com/crate/crate/issues

Best regards