#1054-未知列-SQL查询问题 [英] #1054 - Unknown column - SQL Query Problem

查看:150
本文介绍了#1054-未知列-SQL查询问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

可能重复:
原因:不是唯一表::现在:# 1054-未知列-无法理解原因?

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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆