Вопрос про Query

[rkrivov]

Цитата:

Сообщение от kashperuk

Попробуйте так.

 
Query q = new Query();
QueryBuildDataSource qbds1;
QueryBuildDataSource qbds2;
QueryRun qr;
;
qbds1 = q.addDataSource(tableNum(CustTable), "CustTable");
qbds2 = qbds1.addDataSource(tableNum(CustTrans), "CustTrans");
qbds2.addRange(fieldNum(CustTrans, RecId)).value(strfmt("((%1.%3 == %2.%4) && (%1.%5 != %2.%6))", 
qbds1.name(), qbds2.name(),
fieldStr(CustTable, AccountNum), fieldStr(CustTrans, AccountNum),
fieldStr(CustTable, RecId), fieldStr(CustTrans, RecId)));

А не поще будет сделать ???

Query q = new Query();
QueryBuildDataSource qbds1;
QueryBuildDataSource qbds2;
;
qbds1 = q.addDataSource(tableNum(table1), "table1");
qbds2 = qbds1.addDataSource(tableNum(table2), "table2");
qbds2.addLink(fieldNum(table1, field1), fieldNum(table2, field2));