Join Orders and Customers Tables

Question

How to join 2 tables?

Accepted Answer

```sql
SELECT orders.id, customers.name 
FROM orders 
INNER JOIN customers ON orders.customer_id = customers.id;
```

This query performs an `INNER JOIN` between the "orders" and "customers" tables to retrieve the order ID and the corresponding customer name based on a matching customer identifier.