草庐IT

sql - MySQL 中的未知列错误 (#1054)

此sql失败:select*fromRRICalloutsasrJOINLevelToCalloutsJTaslcon(`r.__kp_RecID`=`lc._kf_RecID~Callout`)JOINLevelsaslON(`lc._kf_RecID~Level`=`l.__kp_RecID`)where`l.__kp_RecID`=201006221644060009#1054-Unknowncolumn'l.__kp_RecID'in'whereclause这个有效:select`__kp_RecID`fromLevelsasl;在某些linux变体上使用MySQL5.0.77