I have two tables customers and orders, below is the structure.

**Table - customers**

* id
* customer\_name

**Table - orders**

* id
* order\_id
* customer\_id

customers table have customers records and orders table have orders placed by customers, 

**customer\_id** in orders table is linked to the **id** field of customers table.

Now one customer can have zero or one or more than one orders, i want to get the last order placed by customers only.

when i run the following query a simple invisible join, it returns all the orders by the customer

```
SELECT customers.customer_name,orders.order_id FROM orders,customers WHERE orders.customer_id=customers.id

```

I have also tried different JOIN statements but cannot get the last order by the customer, i want to get it in one SQL query for all customers.

Thank you in advance for your help.