Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE trabajador_documento td1 set td1.obsoleto = 1 WHERE td1.id NOT IN(
- SELECT v1.td_id FROM (
- select
- t.id as trabajador_id,
- f.id as faena_id,
- c.id as cargo_id,
- max(td.id) as td_id,
- t.nombre as nombreTrabajador,
- f.nombre as nombreFaena,
- d.nombre as nombreDocumento,
- td.fechaVencimiento as vencimiento
- from
- trabajador t,
- faena f,
- cargo c,
- trabajador_documento td,
- documento d
- where
- t.estado_id != 2 and
- t.faena_id = f.id and
- t.cargo_id = c.id and
- td.trabajador_id = t.id and
- td.documento_id = d.id AND
- td.obsoleto = 0
- group by t.id,f.id,c.id,d.id, td.perteneceFaena) v1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement