查询所有顾客购买商品的信息，包括没购买商品的顾客和没被购买的顾客
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
mysql 不支持 FULL JOIN 用left join 或 right join
问重复了？ 你把SQl写在一行里执行，看看报错
用 left join ... union all . right join