CAP: join in event handler doesn't work

Hi community,

I'm trying to join two tables in my Node.js event handler. Although the sql runs without error, the result is null.

I've confirmed that the join partner (BusinessPartnerSalesAreaData) does exist. Am I missing anything?

	const { BusinessPartnerBasicData, BusinessPartnerSalesAreaData } = this.entities

        const { SalesOrganization } = await SELECT 
                          .one (`${BusinessPartnerBasicData.name} as A`) 
                          .join (`${BusinessPartnerSalesAreaData.name} as B`) 
                          .on('A.toSalesArea_ID','=','B.ID')
                          .columns `B.SalesOrganization`
                          .where `A.ID = ${id}`<br>

If I execute 2 sqls sequentially I can get SalesOrganization.

        const { toSalesArea_ID } = await SELECT 
                                    .one (BusinessPartnerBasicData)
                                    .columns `toSalesArea_ID`
                                    .where `ID = ${id}`

        const { SalesOrganization } = await SELECT 
                                      .one (BusinessPartnerSalesAreaData) 
                                      .columns `SalesOrganization`
                                      .where `ID = ${toSalesArea_ID}`<br>

@sap/cds version: 6.3.2

Ive referenced the following threads.

https://answers.sap.com/questions/13038904/how-to-performing-a-join-using-cqn-using-fluid-nod.html

https://answers.sap.com/questions/13089606/sap-cap-how-to-do-join.html

Best regards,

Mio