Mysql子查询顺序
mysql 子查询中结果的顺序会影响实际查询的顺序吗?我试过了，但没有得到真正的结果，因为有时看起来如此，有时却不然.
Does the order of the results inside a mysql subquery affect the order of the actual query? I tried it but did not came to a real result cause sometimes it seemed so and sometimes it doesn't.
例如:
SELECT name FROM people WHERE pid IN (SELECT mid FROM member ORDER BY mdate)
在这种情况下，order by"子句会影响结果的顺序吗?
Is the "order by"-clause going to affect the order of the results in this case?
谢谢.
推荐答案
不行，如果你想根据需要更改顺序，最好使用 JOIN
No it cant and if you want to change the order as per your need then better use a JOIN
类似这样的:-
select name
from people p inner join member m on p.pid = m.mid
order by p.name
相关文章