PHP код:
query q = new Query();
QueryRun qr;
InventTrans tbl;
;
Q.addDataSource(tablenum(InventTable), "InventTable");
Q.dataSourceTable(tablenum(InventTable)).
addDataSource(tablenum(InventTrans), "InventTrans");
Q.dataSourceTable(tablenum(InventTrans)).joinMode(JoinMode::InnerJoin);
/*
//1-й вариант
Q.dataSourceTable(tablenum(InventTrans)).addLink(fieldnum(InventTable, ItemId), fieldnum(InventTrans, ItemId));
Q.dataSourceTable(tablenum(InventTrans)).addRange(fieldnum(InventTrans, DateFinancial)).
value("02082005..31082005");*/
//или
//2-й вариант
Q.dataSourceTable(tablenum(InventTrans)).addRange(fieldnum(InventTrans, itemid)).
value("((InventTable.itemId == InventTrans.itemId) && (InventTrans.DateFinancial > 01\\\\08\\\\2005) && (InventTrans.DateFinancial <= 31\\\\08\\\\2005))");
qr = new QueryRun(q);
while (qr.next())
{
tbl = qr.getNo(2);
info(date2str(tbl.DateFinancial,123,2,2,2,2,4));
}
Но в таком виде запрос очень плохой - сканируется InventTrans в поиске диапазона дат