UPDATE
tlstatus
INNER JOIN instance_properties ON
instance_properties.instance_id = tlstatus.instance_id and
tlstatus.instance_id=3 AND
instance_properties.object_id = tlstatus.object_id AND
instance_properties.direction = 2 AND
tlstatus.is_resubmission=0 AND -- nicht wiedervorlegt
tlstatus.resubmission_date is null AND -- keine wiedervorlage eingerichtet
tlstatus.is_globalize=0 AND -- nicht geteilt
instance_properties.chatsession_id=0 -- nicht geteilt
SET tlstatus.resubmission_sort_date = instance_properties.object_date
WHERE tlstatus.resubmission_sort_date is NULL |