mysql使用full join报错

https://www.w3school.com.cn/sql/sql_join_full.asp
full join 出现图中错误

参考https://blog.csdn.net/lukabruce/article/details/80568796
Oracle 支持full join
mysql不支持full join,但可通过左外连接(left join)+union+右外连接(right join)来实现。

full join语句可改为

select persons.last_name, persons.first_name,orders.order_no
from persons
left join orders
on persons.id_p = orders.id_p
union
select persons.last_name, persons.first_name,orders.order_no
from persons
right join orders
on persons.id_p = orders.id_p;

可实现相同的结果