![]() |
#17 |
Участник
|
Забыл link
X++: QueryRun qr = SYS_ExpressionQueryBuilder::addDataSource(tableNum(CustTable)) .count(fieldNum(CustTable, recID)) .exists(tableNum(CustTrans)) .link(fieldNum(CustTable, AccountNum), fieldNum(CustTrans, AccountNum)) .matches(fieldNum(CustTrans, AmountCur), '>100') X++: SELECT COUNT(A.RECID) FROM CUSTTABLE A WHERE (A.DATAAREAID='dat') AND EXISTS (SELECT 'x' FROM CUSTTRANS B WHERE ((B.DATAAREAID='dat') AND ((B.AMOUNTCUR>1.E2) AND (A.ACCOUNTNUM=B.ACCOUNTNUM)))) OPTION(FAST 5) |
|
|
За это сообщение автора поблагодарили: Prof (2). |