列出昨天写的query,mark not exists 的用法。

    select         tcibd007.item,
                      tcibd007.ecpr(1),
                      tcibd001.kitm,
                      tcibd001.csig
    from           tcibd007,tcibd001
    where          not exists
                      (select item from ticpr170 where tcibd007.item=ticpr170.item)
    and             tcibd007.ecpr(1) = 0
    and             tcibd007.item=tcibd001.item
    and             tcibd001.kitm=1