Query from table with where clause NOT IN another sub query?

For ex: select * from TableA where email not in (select email from TableB); ?

2 Replies

Here's what I'm trying:

const results = await db
    .select({
      ...getTableColumns(employeeTable),
    })
    .from(employeeTable)
    // .leftJoin(usersQuery, eq(employeeTable.workEmail, usersQuery.email)
    .where(notInArray(employeeTable.workEmail, usersQuery))
    .limit(limit);

const results = await db
    .select({
      ...getTableColumns(employeeTable),
    })
    .from(employeeTable)
    // .leftJoin(usersQuery, eq(employeeTable.workEmail, usersQuery.email)
    .where(notInArray(employeeTable.workEmail, usersQuery))
    .limit(limit);

Dan•2y ago

the docs have this exact example: https://orm.drizzle.team/docs/operators#notinarray

Filter and conditional operators – DrizzleORM

Drizzle ORM | %s

Gaming

Programming

Query from table with where clause NOT IN another sub query?