mysql 左连接 加号_mysql查询中的复杂语句，当用左连接left join查询时，加上UNION查询就会出现错误！...

原语句是这样的“selectb.*,c.gb_nameashost_gb_name,c.big5_nameashost_big5_name,d.gb_nameasguest_gb_name,d.big5_nameasguest_big5_namefrom(match_detailasbleftjointeamasconb....

原语句是这样的

“select b.*,c.gb_name as host_gb_name,c.big5_name as host_big5_name,d.gb_name as guest_gb_name,d.big5_name as guest_big5_name from (match_detail as b left join team as c on b.host_id=c.team_id) left join team as d on b.guest_id=d.team_id where b.match_id=1"

总共32个字段

然后后面加上UNION查询，竟然出错，为什么呢？

“select b.*,c.gb_name as host_gb_name,c.big5_name as host_big5_name,d.gb_name as guest_gb_name,d.big5_name as guest_big5_name from (match_detail as b left join team as c on b.host_id=c.team_id) left join team as d on b.guest_id=d.team_id where b.match_id=1 and union select 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32"

竟然

查询数据库失败!

为什么？

难道left join查询以后不可以用UNION查询了？

不要and也不行。。加引号也不管用…………

展开