Join Source

最新推荐文章于 2023-02-08 18:15:07 发布

weixin_33958585

最新推荐文章于 2023-02-08 18:15:07 发布

阅读量535

点赞数

原文链接：http://www.cnblogs.com/lingdanglfw/archive/2008/08/13/1267039.html

版权

    info("Begin:"+queryvalue(timenow()));
    ttsbegin;
    while select _invTrans
    join _invTable
         where _invTrans.JournalId == _invTable.JournalId &&
                _invTable.BSEFinishKind == BSEFinishKind::Normal &&
                _invTable.JournalNameId == SalesParameters::find().JournalNameId
    join _saTBL
         where _invTable.SalesId == _saTBL.SalesId

{
iNum ++;

    }
    ttscommit;
/*
    ttsbegin;
    while select _invTable
    where _invTable.BSEFinishKind == BSEFinishKind::Normal &&
          _invTable.JournalNameId == SalesParameters::find().JournalNameId
    {
        while select _invTrans
        where _invTrans.JournalId == _invTable.JournalId
        {
            //select _saTBL
            //where _saTBL.SalesId == _invTable.SalesId;
            iNum ++;
        }
    }