每个派生表在C:\examplep\htdocs\company directory\home.php中都必须有

Question

我遇到这个错误，请帮助。提前感谢

SELECT companies.company_name
FROM (SELECT companies.company_name FROM companies
WHERE companies.profile_progress BETWEEN 80 AND 100)
ORDER BY RAND() LIMIT 10

致命错误：未捕获的PDOException:SQLSTATE[42000]：语法错误或访问冲突：1248每个派生表都必须在C:\examplep\htdocs\company directory\home.php中有自己的别名：10堆栈跟踪：#0 C:\examplep\ htdocs\ company directory \home.php(10(：PDOStatement->execute((#1｛main｝在C:\examplep\htdocs\company directory\home.php的第10行中抛出

Answer 1

您可以使用此代码。我认为它应该起作用：

SELECT a.company_name FROM 
(SELECT companies.company_name 
FROM companies WHERE  companies.profile_progress 
BETWEEN 80 AND 100) a ORDER BY  RAND() LIMIT 10