How can I do a join query for the sole purpose of filtering?

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);

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 = ?