TypeORM - Join without selection

Join with selection

const user = await createQueryBuilder("user")
    .innerJoinAndSelect("user.photos", "photo")
    .where("user.name = :name", { name: "Timber" })
    .getOne()

SELECT user.*, photo.* FROM users user
    INNER JOIN photos photo ON photo.user = user.id
    WHERE user.name = 'Timber'

Join without selection

const user = await createQueryBuilder("user")
    .innerJoin("user.photos", "photo")
    .where("user.name = :name", { name: "Timber" })
    .getOne()

SELECT user.* FROM users user
    INNER JOIN photos photo ON photo.user = user.id
    WHERE user.name = 'Timber'

참고)

• https://typeorm.io/select-query-builder#join-without-selection
• https://velog.io/@josworks27/TypeORM-Join
• https://velog.io/@hkja0111/NestJS-08-TypeORM-QueryBuilder