Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- products.name AS name,
- products.category AS category,
- products.units AS units,
- products.weight AS weight,
- products_stores.price AS price
- FROM
- products
- INNER JOIN products_stores ON products_stores.id_product = products.id_product
- WHERE
- products.units = 'мл' and CAST(products_stores.date_upd AS date) = '2019-06-13'
Advertisement
Add Comment
Please, Sign In to add comment