X++ Query（表连接）

private void createQuery()
{
    SalesTable salesTable;
    SalesLine salesLine;
    
    Query q = new Query();

　　//设置主数据源
    QueryBuildDataSource qbdsSalesTable = q.addDataSource(tablenum(SalesTable));

    //设置连接表数据源
    QueryBuildDataSource qbdsSalesLine = qbdsSalesTable.addDataSource(tablenum(SalesLine));
    //连接模式
    qbdsSalesLine.joinMode(JoinMode::InnerJoin);

    //连接表原有的连接是否有效
    qbdsSalesLine.relations(false);

    //连接条件，主表字段在前，连接表字段在后面    
    qbdsSalesLine.addLink(fieldNum(SalesTable,SalseId),
                          fieldNum(SalesLine,SalseId));
    //添加where查找条件
    qbdsSalesTable.addRange(fieldnum(SalesTable,SalesId)).value('00001_036');

    //添加orderby
    qbdsSalesTable.addSortField(fieldnum(SalesTable,SalesId),SortOrder::Descending);

    //统计count函数
    qbdsSalesTable.addSelectionField(fieldnum(SalesTable,RecId),Selection::Count);

    //Query执行
    QueryRun qr = new QueryRun(q);
    while(qr.next())
    {
        salesTable = qr.get(tableNum(SalesTable));
        salesLine = qr.get(tableNum(SalesLine));
    }
          
}