Select SQL field?

Question

MySQL

There are two tables orders_list and goods , linked via good_id and id . We need to get the product names for the last week ( orders_list table ), from the goods table , so that they don't repeat. How to build a query correctly?

Answer 1

select what your need from orders_list as ol
INNER JOIN goods as g ON g.id = ol.good_id
WHERE --условие на дату
GROUP BY g.id, g.name