Solutionunvalidated
you'd have to use an exists subquery to model this — For now. Tension: That's not yet possible. Outcome: update PushPermission p set p.exampleField=true where exists ( select 1 from product pr where p.id=pr.id and pr.feed<>'PROMO'; ).
f73849f4-cca1-434f-90bf-1dbcbb4fbd1a
you'd have to use an exists subquery to model this — For now. Tension: That's not yet possible. Outcome: update PushPermission p set p.exampleField=true where exists ( select 1 from product pr where p.id=pr.id and pr.feed<>'PROMO'; ).