查询以下SQL数据库中的所有客户及其订单。


数据库:
表1：customer
字段：id, name, email
表2：order
字段：id, customer_id, date, amount
SQL查询语句：
SELECT c.name, o.date, o.amount FROM customer c JOIN order o ON c.id = o.customer_id
The SQL query retrieves all customers and their orders from the following database:

Database:
Table 1: customer
Fields: id, name, email
Table 2: order
Fields: id, customer_id, date, amount

SQL query:
SELECT c.name, o.date, o.amount FROM customer c JOIN order o ON c.id = o.customer_id