question about partial query for joins

    const result = await db
        .select()
        .from(candidateProfileTable)
        .where(eq(candidateProfileTable.id, candidateId))
        .innerJoin(userTable, eq(candidateProfileTable.userId, userTable.id))
        .innerJoin(disciplineTable, eq(candidateProfileTable.disciplineId, disciplineTable.id))
        .innerJoin(regionTable, eq(candidateProfileTable.regionId, regionTable.id))
        .leftJoin(subRegionTable, eq(regionTable.id, subRegionTable.regionId));