Join Example SQL query

sql-join.sql

SELECT 
  orders.order_id,
  orders.order_date,
  orders.first_name,
  orders.last_name
FROM orders
INNER JOIN customers ON orders.order_id = customers.customer_id
LIMIT 50;