mysql - sql 子查询返回 "Every derived table must have its own alias"

Question

我在我的服务器上执行了这个查询并得到了

$query1="select clients.name AS client,
packages.pick AS pick,
packages.drop AS `drop`,
packages.created AS created,
packages.status AS status,
packages.id AS id,
packages.name AS package
 from  (packages join clients on(clients.id = packages.client_id))";

$result = $mysqli->query("select count(*) as num from ($query1)");

我得到了上面的错误，知道是什么导致了这个错误吗？

Answer 1

必须命名子查询:

from ($query1) as SubQueryAlias