12311k

Untitled

Mar 7th, 2020
2,823
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. SELECT
  2. products.name AS name,
  3. products.category AS category,
  4. products.units AS units,
  5. products.weight AS weight,
  6. products_stores.price AS price
  7. FROM
  8. products
  9. INNER JOIN products_stores ON products_stores.id_product = products.id_product
  10. WHERE
  11. products.units = 'мл' and CAST(products_stores.date_upd AS date) = '2019-06-13'
Advertisement
Add Comment
Please, Sign In to add comment