Left Join vs Inner Join

Explain the difference between a left join and an inner join in SQL.

Use a company's customer and order data to demonstrate the difference with query results. Show all customers and indicate whether an order match exists.

Output

1. One row per company customer and matching order, including customers without orders.
2. Columns: customer_id, customer_name, order_id, and match_status.
3. Sort by customer_id, then order_id, with unmatched customers shown clearly.

Output details

• Sort customer_id and order_id in ascending order.
• Place unmatched customers with order_id NULL after customers with orders.
• Use match_status value matching order when an order exists and no matching order otherwise.