Sage 100 2019 Sage Intelligence. Company name or code for multi-company reports.

Sage 100 2019 Sage Intelligence. How do I add company code from the SYO_Company table to my joins? In Crystal we would use "Not Equal" as a join for company name. In SI, Connector, there is only Right Join, Inner, and Outer. How do I get the company name for my multi-company reports.

Thank you,

Paula Park