Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select e.id_asignacion,
- e.id_item,
- e.serie,
- id_funcionario,
- id_operacion,
- i.precio_unitario,
- min(nro_valorada) as minimo,
- max(nro_valorada) as Fin,
- count(e.id_item) as cantidad
- from ejecucions e
- INNER JOIN inventarios i on i.id_item=e.id_item
- INNER JOIN asignacions a on a.id_asignacion=a.id_asignacion
- GROUP BY e.id_item,e.id_asignacion,e.serie,id_operacion,id_funcionario,i.precio_unitario;
Add Comment
Please, Sign In to add comment