Good morning. Does anyone know how to find a custo...
# suiteqle
Eystein Bye
01/30/2023, 8:09 AMGood morning. Does anyone know how to find a customers subsidiary with SuiteQL ?
Eystein Bye
01/30/2023, 11:29 AMThe table
EntitySubsidiaryRelationship Copy code
SELECT c.id, c.companyname, er.subsidiary, er.name
FROM Customer AS c
INNER JOIN EntitySubsidiaryRelationship AS er
ON c.id = er.entity4 Views