Join Example Drizzle ORM query

drizzle-orm-join.ts

.select({
  id: orders.order_id,
  order_date: orders.order_date,
  first_name: orders.first_name,
  last_name: orders.last_name,
})
.from(orders)
.innerJoin(customers, eq(orders.order_id, customers.customer_id))
.limit(50);