I have this loantypeid that is foreign key in loanproduct table and primary key inside loantype table
@Entity()
export class loanproduct {
@PrimaryColumn({ default: () => 'uuid_generate_v4()' })
loanid: string;
@ManyToOne(() => loantype, (type: loantype) => type.loantypeid)
loantypeid: string;
}
@Entity()
export class loantype {
@PrimaryColumn({ default: () => 'uuid_generate_v4()' })
@OneToMany(() => loanproduct, (loanproduct) => loanproduct.loantypeid)
loantypeid: string;
@Column()
content: string;
}
My question is when i run my code with leftJoinAndSelect
.createQueryBuilder('loanproduct')
.leftJoinAndSelect('loanproduct.loantypeid', 'loantype')
It generate wrong SELECT QUERY:
SELECT
"loanproduct"."loanid" AS "loanproduct_loanid",
"loanproduct"."loantypeidLoantypeid" AS "loanproduct_loantypeidLoantypeid",
"loantype"."loantypeid" AS "loantype_loantypeid",
"loantype"."content" AS "loantype_content"
FROM "loanproduct" "loanproduct"
LEFT JOIN "loantype" "loantype"
ON "loantype"."loantypeid"="loanproduct"."loantypeidLoantypeid
It's adding Loantypeid inside "loantypeid"