Joining the same table several times?

Hello there,

a (Zoho CRM) table is given with, among other things, two columns that have a company ID. The base table therefore points twice to the company table. I have set up the lookups accordingly.

Base table with "CRM_Unternehmen_ID" und "CRM_übergeordnetes_Unternehmen_ID":

Lookups:

If I now want to create a pivot table, I would have expected it to work like this:
I drag columns twice from the same table into my pivot table:

and then configure the JOIN conditions. But that doesn't work because I only have one path...

How can I access the same table twice with different JOIN conditions? No problem as a query table, but this way...?!

Regards,

Sven