Hi folks, I’m new to SuiteAnalytics, I’m trying to get Sales order and Customer Name and Item fulfillment within one query from sql server

select * from openquery(NETSUITE, '
select top 10 sales_order.entity_id

from Transactions as sales_order

inner join Customers as customer
on sales_order.entity_id = customer.customer_id and customer.subsidiary_id = 2 

inner join Customers as parent
on customer.parent_id = parent.customer_id

inner join Transactions as iful
on sales_order.TRANSACTION_ID = iful.created_from_id and iful.transaction_type = ''Item Fulfillment''

 WHERE  sales_order.transaction_type = ''Sales Order'' AND  sales_order.[LAST_MODIFIED_DATE]  >  sysdate -11
         
');