mysql - Unknown Column In Where Clause

0
votes

Following Sql query throws error

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

Query:

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

I have both "user_feedback" table and "registered_user_detail" table; also the "user_id" column in both table. Then what's going wrong.

2
phpmysqlsqldatabase
Your query specifies table and field as `user_feedback.user_id`, where it should be `user_feedback`.`user_id` (same for all other tables and fields) - dkasipovic
@Da How I made this type of error ?? However, many many thanx Damir Kasipovic - Arnab Chatterjee

2 Answers

1
votes

You have missed the punctuationmark symbol in where clause,correct use is: (punchmark)tablename(punchmark).(punchmark)columnname(punchmark). Please try with this:

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

0
votes

Use correct JOIN's and consistent back ticks.

SELECT u.user_id, u.feedback_status, r.user_id
FROM user_feedback u
INNER JOIN registered_user_detail r ON u.user_id = r.user_id
WHERE u.feedback_status = 1
ORDER BY u.feedback_id DESC