[Talgat_imported]

Запрос на SQL Server

SELECT w.* FROM dbo.WMSLOCATION w
  WHERE w.INVENTLOCATIONID = N'ЦС_Акб' AND 
        NOT EXISTS(SELECT d.INVENTDIMID FROM dbo.INVENTDIM d
                   INNER JOIN dbo.INVENTSUM i
                     ON (i.INVENTDIMID = d.INVENTDIMID) AND (i.CLOSED = 0) AND (i.CLOSEDQTY = 0)
                   WHERE d.INVENTLOCATIONID = w.INVENTLOCATIONID
                     AND d.WMSLOCATIONID = w.WMSLOCATIONID
                   );

не получается на Axapta-e

void init()
{
    Query                   q;
    QueryBuildDataSource    qbds;
    // <Talgat 10/11/2015 10:43>
    // QueryBuildDataSource    qbdsDim, qbdsSum;
    // </Talgat>
    super();

    q = new Query();
    qbds = q.addDataSource(tablenum(WMSLocation));
    // <Talgat 09/11/2015 10:54>
    qbds = qbds.addDataSource(tablenum(InventDim));
    //qbds = qbds.addDataSource(tableNum(InventSum));

    //qbds.addRange(fieldNum(InventSum, Closed)).value("0");
    //qbds.addRange(fieldNum(InventSum, ClosedQty)).value("0");
    qbds.relations(true);
    qbds.joinMode(JoinMode::NoExistsJoin);
    // </Talgat>
    qbds.addSortField(fieldnum(WMSLocation,InventLocationId));
    qbds.addSortField(fieldnum(WMSLocation,wmsLocationId));

    this.query(q);
}