update module set active = false where code = 'crosscompany'; update operation o,module m set o.active = false where m.id = o.module_id and m.code = 'crosscompany';