Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT `productos`.`codigo_barras`, (
- SELECT
- articulos.costo_us * (1 + articulos.iva_coef)
- FROM
- articulos
- INNER JOIN (
- SELECT
- articulos.id, MAX(encargosProveedor.fecha_entrega)
- FROM
- articulos, encargosProveedor_listado_articulos, encargosProveedor, itemArticulosProveedor
- WHERE
- articulos.id = itemArticulosProveedor.articulos_id AND
- encargosProveedor.id = encargosProveedor_listado_articulos.encargosproveedor_id
- GROUP BY
- articulos.producto_id
- )
- AS ultimos ON articulos.id = ultimos.id
- ) AS `ultimo_precio` FROM `productos`
- +----+--------------------------------------+
- | id | MAX(encargosProveedor.fecha_entrega) |
- +----+--------------------------------------+
- | 1 | 2019-04-17 |
- +----+--------------------------------------+
- | 3 | 2019-04-17 |
- +----+--------------------------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement