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
没看出语法问题，如果你是复制粘贴的，那么这个full 前面，要不你加个空格看看
或者，你把整个SQL 放到一行，执行。
直接查询*不就好了？
left join或者right join，其它的没听过，full join是在一起吗，还是说full是一个别名?