I don t think you can combine an update with an inner join kotlinlang #spring

I don’t think you can combine an update with an in...

pavel

11/21/2019, 10:06 PM

I don’t think you can combine an update with an inner join

Thiago Nerys

11/22/2019, 12:59 PM

Sure you can!

Copy code

update a
set a.field = b.field
from TableA a
inner join TableB b on a.b_id = b.id
where b.filter = 'value'

3 Views