原SQL
select a.*,b.*
from info a ,category b
where a.id = b.id and b.id=#{id}
问题报错
Unknown column ‘id’ in ‘on clause’
修改后SQL
select a.*,b.*
from (info a ,category b)
where a.id = b.id and b.id=#{id}
原因
MySQL5.0 Bug, 要把联合的表用括号包含起来
原SQL
select a.*,b.*
from info a ,category b
where a.id = b.id and b.id=#{id}
问题报错
Unknown column ‘id’ in ‘on clause’
修改后SQL
select a.*,b.*
from (info a ,category b)
where a.id = b.id and b.id=#{id}
原因
MySQL5.0 Bug, 要把联合的表用括号包含起来