One very useful thing you might need while working on your app is joining 2 tables.

For example, you have a products table and an orders table, and the orders table has the id of a product ordered in product_id, but the product name is in the products table.

And you want to get the name of a product that’s been ordered.

You can use the .innerJoin() method of Kysely to join the orders table with products, joining on products.id and orders.product_id:

await db
  .selectFrom('orders')
  .innerJoin(
    'products',
    'products.id',
    'orders.product_id'
  )
  .select('products.name')
  .execute()

Lessons in this unit:

0:	Introduction
1:	Installing Kysely
2:	Select queries
3:	Inserting data
4:	Deleting data
5:	Updating data
6:	▶︎ Joins