Left / Right / Full Join in Drizzle ORM

From the Drizzle ORM cheat sheet · Joins · verified Jul 2026

Left / Right / Full Join

Return all rows from one or both tables, even without matches.

typescript

import { eq } from 'drizzle-orm';

// Left join — all users, even without posts
const result = await db.select({
  userName: users.name,
  postTitle: posts.title, // nullable!
}).from(users)
  .leftJoin(posts, eq(users.id, posts.authorId));

💡 Left join makes right-side columns nullable

⚡ Chain multiple joins for complex queries

📌 Full join makes both sides nullable

🟢 Drizzle adjusts TS types per join type

joinleft-joinright-joinfull-join

More Drizzle ORM tasks

Inner Join

Back to the full Drizzle ORM cheat sheet