查询语句:
select 分数 from c
full join d
on c.姓名=d.姓名
报错:
[Err] 1054 - Unknown column ‘c.姓名‘ in ‘on clause‘
经测试:
full join 报错,
join,没问题,
left join 没问题,
right join 没问题
mysql|full join 多表联查,系统报错,无法解答!
原文:https://www.cnblogs.com/susuye/p/10589616.html