Kysely: Joins

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

For example you have a products table and a orders table and orders 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

Are you intimidated by Git? Can’t figure out merge vs rebase? Are you afraid of screwing up something any time you have to do something in Git? Do you rely on ChatGPT or random people’s answer on StackOverflow to fix your problems? Your coworkers are tired of explaining Git to you all the time? Git is something we all need to use, but few of us really master it. I created this course to improve your Git (and GitHub) knowledge at a radical level. Launching May 21, 2024. Join the waiting list!