mysql - 左连接 - 未知列错误 1054

Question

我不断收到 #1054 - “where 子句”中的未知列“颜色”。

我的查询的简化版本如下。

SELECT *, "red" AS colour
FROM (
    SELECT *,'calls' AS 'tbl', id AS cid FROM calls) as c
WHERE colour='red' 
ORDER BY colour ASC, c.created_date DESC

如果我删除 WHERE 行，查询执行正常并且颜色被识别，一切都很好。

如有任何帮助，我们将不胜感激。

Answer 1

对于您更新的问题，我认为您可以这样做

SELECT * FROM (
SELECT *, "red" AS colour
FROM (
    SELECT *,'calls' AS 'tbl', id AS cid FROM calls) as c
) as v
WHERE colour='red' 
ORDER BY colour ASC, v.created_date DESC