Address 为Innodb表,AppUser 为FEDERATED表,下面的连接查询如果用INNER JOIN 就正常,用left join连接的结果Name全为null,即使有匹配的行,怀疑是mysql的bug
select a.*,b.Name from Address AS a
LEFT JOIN AppUser AS b ON b.AID = a.CheckAdminID
where a.AID=1006948
暂时解决办法:将AppUser改名AppUser1,建个视图AppUser引用AppUser1,结果正常。
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/124805/viewspace-979388/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/124805/viewspace-979388/