Hi everyone, I need the relationship between customer -> name of primary subsidiary ( text under Field ID: subsidiary) I found the path Customer -> left join CustomerSubsidiaryRelationship -> left join Subsidiary However, I was curious is there any other field in customer table which gives information about Name of primary subsidiary without using so many joins? Thank you, Irina

You can use the

BUILTIN.DF

function to get the subsidiary name without a join.

SELECT 
BUILTIN.DF(CustomerSubsidiaryRelationship.subsidiary) as subsidiary,

Thank you, Edgar :)