How to rewrite the query without group by?

SELECT, customers.`full_name`,,
FROM customers
LEFT JOIN orders ON orders.`customer_id` =
LEFT JOIN stores ON stores.`id` = orders.`store_id`

The relationship between customers and orders is one to many.
I need a LEFT JOIN to pick up only the first orders
What is the most appropriate(efficient) option to do this?
June 10th 19 at 14:38
0 answer

Find more questions by tags MySQL