SQL question: join two tables.
Use the provided customers and orders tables. Return customer details alongside each matching order record. Include only records where the customer and order are related.
customer_id, customer_name, order_id, and order_totalcustomer_id ascending, then order_id ascending| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer display name |
| customer_segment | VARCHAR(30) | Customer segment |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| customer_id | INT | Customer associated with the order |
| order_total | DECIMAL(10,2) | Total order amount |
| order_status | VARCHAR(20) | Current order status |