Implement Query Objects and Query Builder – Joins

For more information about query objects and the query builder, see the following sites:​

Advanced filtering and query syntax

QueryBuildDataSource Class

How to: Create Queries by Using X++

The Query object model section