+———-+————+
| id | name |
+———-+————+
| 1 | storeone |
| 2 | storetwo |
| 3 | storethree|
+———-+————+
+———-+————+————+
| id | storeid | date |
+———-+————+————+
| 1 | 1 | 2024-07-01 |
| 2 | 2 | 2024-06-01 |
| 3 | 3 | 2024-07-22 |
| 4 | 2 | 2024-06-11 |
| 5 | 3 | 2024-06-14 |
+———-+————+————+
i have used the following query
SELECT o.*,s.name FROM orders as o LEFT JOIN stores as s ON s.id = o.storeid ORDER BY o.date,s.id;
am getting the following result
+———-+————+————+————-
| id | storeid | date | name
+———-+————+————+————-
| 2 | 2 | 2024-06-01 | storetwo |
| 4 | 2 | 2024-06-11 | storetwo |
| 5 | 3 | 2024-06-14 | storethree |
| 1 | 1 | 2024-07-01 | storeone |
| 3 | 3 | 2024-07-22 | storethree |
+———-+————+————+————-
but i want like this
+----------+------------+------------+-------------
| id | storeid | date | name
+----------+------------+------------+-------------
| 2 | 2 | 2024-06-01 | storetwo |
| 4 | 2 | 2024-06-11 | storetwo |
| 5 | 3 | 2024-06-14 | storethree |
| 1 | 1 | 2024-07-22 | storethree |
| 3 | 3 | 2024-07-01 | storeone |
+----------+------------+------------+-------------
vaiheesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.