php - mysql - Where 子句中的未知列

Question

以下 Sql 查询抛出错误

1054 - Unknown column 'registered_user_detail.user_id' in 'where clause'

查询:

SELECT
  `user_feedback`.`user_id`,
  `user_feedback`.`feedback_status`,
  `registered_user_detail`.`user_id`
FROM
  `user_feedback`,
  `registered_user_detail`
WHERE
  `registered_user_detail.user_id` = `user_feedback.user_id` AND `user_feedback.feedback_status` = 1
ORDER BY
  `user_feedback.feedback_id`
DESC

我有“user_feedback”表和“registered_user_detail”表；还有两个表中的“user_id”列。那到底是哪里出了问题。

Answer 1

您在where子句中漏掉了标点符号，正确的用法是:(punchmark)表名(punchmark).(punchmark)列名(punchmark)。请尝试这样做:

选择 user_feedback.user_id, user_feedback.feedback_status, registered_user_detail.user_id从 用户反馈， 注册用户详细信息在哪里 registered_user_detail.user_id = user_feedback.user_id 并且user_feedback。feedback_status = 1订购依据 user_feedback.feedback_id描述