Забыл 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)