SQL update mit Bedingung aus anderer Tabelle

[mkinzler]

Beide Bedingungen in ein OR packen

SQL-Code:

update a set Aktwert = 0
where a.Reference in (
  select 
    a.Reference
  from 
    a, b
  where
    (a.Reference is null and
     a.DORESET is true) or
    (a.Reference = b.Reference and
     a.Reference is not null and
     b.DoReset = true)
)