使用N/query查询Customer和它的subsidiary实例

这个和N/search的不同之处在于实际上customer和customersubsidiaryrelationship是两张分开的表，需要用innerjoin联查。

实例代码如下

select customer.id, CustomerSubsidiaryRelationship.subsidiary 
from customer 
INNER JOIN CustomerSubsidiaryRelationship 
ON (Customer.ID = CustomerSubsidiaryRelationship.entity) 
where customer.companyname = 'netsuiteful.com'  
AND 
CustomerSubsidiaryRelationship.subsidiary = 1