mysql下出现Unknown column ‘id‘ in ‘on clause‘的解决方法
原因:这是一个MySQL5.0 的Bug, 要把联合的表用括号包含起来才行:例子:Sql代码SELECT (c.id, a.id, b.id) FROM (A a, B b) LEFT JOIN C c ON c.a_id = a.a_id AND c.b_id = b.b_id源文章:http://www.2cto.com/database/201203/124307.html...
转载
2020-07-18 17:28:46 ·
2806 阅读 ·
0 评论