PHP SQL按其他表排序

PHP SQL order by other table

本文关键字：排序其他 SQL PHP | 更新日期: 2023-09-27

我希望能够从数据库的内部选择中排序列表。我的代码：

$sql = "SELECT * from `users` WHERE `name` in (select `last` from info where `date` = '2013' ORDER BY  `id` DESC)";

我希望能够从表last而不是users中获得订单。

$sql = "SELECT u.* from `users` u JOIN `info` i ON u.name = i.last WHERE i.date = '2013' ORDER BY i.id DESC";