MySQL用不来full join怎么办？

Question

查询所有顾客购买商品的信息，包括没购买商品的顾客和没被购买的顾客
mysql> select customer. * ,goods. * ,orderdate,amount

-> from customer full join orders on customer.cno=orders.cno

-> full join goods on goods.gno=orders.gno;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'full join goods on goods.gno=orders.gno' at line 3

Answer 1

mysql 不支持 FULL JOIN 用left join 或 right join