#1054-未知列-SQL查询问题 [英] #1054 - Unknown column - SQL Query Problem
本文介绍了#1054-未知列-SQL查询问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Possible Duplicate:
Was: Not unique table :: Now: #1054 - Unknown column - can't understand why?
在解决了该查询的上一个问题之后,我现在陷入了该错误:
After having solved a previous issue with this query, i'm now stuck with getting this error:
1054-"on子句"中的未知列"calendar_events.jobID"
1054 - Unknown column 'calendar_events.jobID ' in 'on clause'
我不明白为什么...该专栏绝对存在!与查询底部的WHERE blah AND ...部分有关吗?
I can't undertstand why... and the column defiantly exists! Is it something to do with the WHERE blah AND ... section of the query at the bottom?
SELECT calendar_events.* ,
calendar_users.doctorOrNurse,
calendar_users.passportName,
calendar_jobs.destination
FROM `calendar_users` , `calendar_events`
INNER JOIN `calendar_jobs` ON `calendar_events.jobID` = `calendar_jobs.jobID`
WHERE `start` >=0
AND calendar_users.userID = calendar_events.userID
任何帮助将不胜感激!
欢呼
推荐答案
You should use `calendar_events`.`jobID` instead of `calendar_events.jobID`.
这篇关于#1054-未知列-SQL查询问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文