KiKo
KiKo
Explore posts from servers
TTCTheo's Typesafe CultDTDrizzle Team
PostsComments
DTDrizzle Team
Created by KiKo on 11/26/2023 in #help
How can I do a join query for the sole purpose of filtering?
Essentially my question is how can I do this better in drizzle. 
const myTeams = await ctx.db
      .select()
      .from(teams)
      .innerJoin(
        members,
        and(eq(members.teamId, teams.id), eq(members.userId, ctx.user.id)),
      );

    return myTeams.map((t) => t.team);
const myTeams = await ctx.db
      .select()
      .from(teams)
      .innerJoin(
        members,
        and(eq(members.teamId, teams.id), eq(members.userId, ctx.user.id)),
      );

    return myTeams.map((t) => t.team);
I really want to just write 
SELECT T.*
FROM teams T, members M
WHERE T.id = M.teamId
AND M.userId = ?
SELECT T.*
FROM teams T, members M
WHERE T.id = M.teamId
AND M.userId = ?
23 replies