主页 / dba / 问题 / 122323
Accepted
mesqueeb
Asked: 2015-11-28 20:01:32 +0800 CST

列存在时出现查询错误“未知列”

  • 772


我收到错误(1054): Unknown column 'wp_jpnx_survey_code.supplier_id' in 'field list'
但是该列确实存在...有谁知道为什么或如何解决这个问题？

这是我使用的代码：

CREATE VIEW survey_codes_complete_overview AS SELECT *,
wp_jpnx_survey_code.supplier_id AS a_id,
wp_jpnx_survey_supplier_info.supplier_id AS b_id FROM
wp_jpnx_survey_code AS a LEFT JOIN wp_jpnx_survey_supplier_info AS b
ON a.supplier_id = b.supplier_id;
mysql

1 个回答

  1. Best Answer

    您正在为这些表使用别名。因此，在选择列时指定别名。

    CREATE VIEW survey_codes_complete_overview AS 
SELECT *, 
a.supplier_id AS a_id, 
b.supplier_id AS b_id 
FROM wp_jpnx_survey_code AS a 
LEFT JOIN wp_jpnx_survey_supplier_info AS b 
ON a.supplier_id = b.supplier_id
    • 2

相关问题