SQL запрос

[Wamr]

qu = new query();
qbds = qu.addDataSource(tableNum(LedgerJournalTrans));
qbds.AddRange(fieldnum(LedgerJournalTrans, TransDate)).value('>' + queryvalue(headerTransDate));

qbds = qbds.addDataSource(tableNum(LedgerJournalTable));

qbds.joinMode(joinMode::ExistsJoin);
qbds.addLink(fieldnum(LedgerJournalTrans, JournalNum), fieldnum(LedgerJournalTable, JournalNum));

qbds.AddRange(fieldnum(LedgerJournalTable, Posted)).value(queryvalue(NoYes::Yes));