Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. SELECT `productos`.`codigo_barras`, (
  2. SELECT
  3. articulos.costo_us * (1 + articulos.iva_coef)
  4. FROM
  5. articulos
  6. INNER JOIN (
  7. SELECT
  8. articulos.id, MAX(encargosProveedor.fecha_entrega)
  9. FROM
  10. articulos, encargosProveedor_listado_articulos, encargosProveedor, itemArticulosProveedor
  11. WHERE
  12. articulos.id = itemArticulosProveedor.articulos_id AND
  13. encargosProveedor.id = encargosProveedor_listado_articulos.encargosproveedor_id
  14. GROUP BY
  15. articulos.producto_id
  16. )
  17. AS ultimos ON articulos.id = ultimos.id
  18. ) AS `ultimo_precio` FROM `productos`
  19.  
  20. +----+--------------------------------------+
  21. | id | MAX(encargosProveedor.fecha_entrega) |
  22. +----+--------------------------------------+
  23. | 1 | 2019-04-17 |
  24. +----+--------------------------------------+
  25. | 3 | 2019-04-17 |
  26. +----+--------------------------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement