你好!
我的数据库里有两个表
表(订单)
+--------+----+---------+
| name | id | user_id |
+--------+----+---------+
| order1 | 1 | 3 |
| order2 | 2 | 5 |
| order3 | 3 | 5 |
| order4 | 4 | 1 |
| order5 | 5 | 5 |
+--------+----+---------+
表(报告的订单)
+----------+---------+------------+
| order_id | user_id | time |
+----------+---------+------------+
| 2 | 5 | 1535110516 |
+----------+---------+------------+
| 3 | 5 | 1535166516 |
+----------+---------+------------+
| 5 | 5 | 1535168651 |
+----------+---------+------------+
当我执行这个查询时
SELECT name,id FROM orders
WHERE
user_id=5
AND
id IN (SELECT order_id FROM reported_orders WHERE user_id=5 ORDER BY time DESC )
LIMIT 0, 12
我知道结果了
+--------+----+
| name | id |
+--------+----+
| order2 | 2 |
+--------+----+
| order3 | 3 |
+--------+----+
| order5 | 5 |
+--------+----+
但我想得到这样的结果
+--------+----+
| name | id |
+--------+----+
| order5 | 5 |
+--------+----+
| order3 | 3 |
+--------+----+
| order2 | 2 |
+--------+----+
我用 ORDER BY time DESC
在我的查询中,根据 time
在 reported_orders
但它不起作用
3条答案
按热度按时间vq8itlhq1#
这个问题对我有用。
balp4ylt2#
尝试此查询
vvppvyoh3#
这对我有用。