Can TypeORM join unrelated tables via the BaseEntity.find method instead of queryBuilder?

Question

userRepository.find({
    join: {
        alias: "user",
        leftJoinAndSelect: {
            profile: "user.profile",
            photo: "user.photos",
            video: "user.videos"
        }
    }
});

If I join a table that has no foreign key relation to userRepository, how do I specify which column is to be based on for the join?

question from:https://stackoverflow.com/questions/65839550/can-typeorm-join-unrelated-tables-via-the-baseentity-find-method-instead-of-quer

Answer 1

Waitting for answers