[Antant]

PHP код:

static void Job152(Args _args)
{
    Query                       _query = new Query();
    QueryBuildDataSource        qbdsVendAssort;
    QueryBuildDataSource        qbdsInventTable;
    ;

    qbdsVendAssort = _query.addDataSource(tableNum(VendAssort));
    qbdsVendTable.fetchMode(0);

    qbdsInventTable = qbdsVendAssort.addDataSource(tableNum(InventTable), 'tInventTable');
    qbdsInventTable.joinMode(JoinMode::InnerJoin);
    qbdsInventTable.fetchMode(0);
    qbdsInventTable.relations(true);

    qbdsInventTable.addLink(fieldNum(VendAssort, AccountNum), fieldNum(InventTable, prVendor));

info(qbdsInventTable.toString());
} 


получается:

SELECT * FROM InventTable WHERE InventTable.ItemId = VendAssort.ItemId AND InventTable.ItemGroupId = VendAssort.prVendor