Как получить данные из связ таблиц в динамич запросе?

[yooshi]

query = new Query();
query.addDataSource(tablenum(InventTrans), "InventTrans");
...
query.dataSourceTable(tablenum(InventTrans)).addDataSource(tablenum(InventTransPosting), "InventTransPosting");

query.dataSourceTable(tablenum(InventTransPosting)).
addLink(fieldnum(InventTrans, InventTransId), fieldnum(InventTransPosting, InventTransId));

query.dataSourceTable(tablenum(InventTransPosting)).addRange(fieldnum(InventTransPosting, InventTransPostingType)).
value(queryValue(InventTransPostingType::Financial));

query.dataSourceTable(tablenum(InventTransPosting)).addRange(fieldnum(InventTransPosting, ItemId)).
value(queryValue(_itemId));
...
while (qr.next())
{
inventTrans = qr.get(tablenum(InventTrans));
inventTransPosting = qr.getNo(2);
}