Re: SQL Problem

This may not perform as well as desired.

select *
from ledger_t A
where Tx_typ = 4
and exists ( select 1
from ledger_t B
where Tx_typ = 92
and A.cid = B.cid
and A.lid > B.lid
and exists ( select 1
from ledger_t C
where Tx_typ = 24
and B.cid = C.cid
and B.lid > C.lid )); Received on Sun Jan 09 2005 - 22:46:50 CST