MySQL错误: Every derived table must have its own alias

Question

这个问题已经有答案了:

What is the error "Every derived table must have its own alias" in MySQL? (4 个回答)

已关闭 9 年前。

我收到此错误

"Every derived table must have its own alias"

当我运行此查询时

SELECT firstname, lastname, artistId
FROM  artist
WHERE artistId=(
    SELECT artistId
    FROM roles
    WHERE movieCode ='$movie[movieCode]' and  role = 'Director'
) a      

Answer 1

$row1=mysqli_query($conn,"
SELECT firstname, lastname, artistId 
FROM  artist WHERE 
artistId=(SELECT artistId FROM roles WHERE movieCode ='$movie[movieCode]' and  role = 'Director') AS table_alias ")or die(mysqli_error($conn));

这应该可行，每个子查询都必须有一个别名“AS”。