Select * From KTrackTagDetail ; >>> where (Seqno In (Select Seqno From C_Kits) ; >>> or SeqnoFG In (Select Seqno From C_Kits)) ; >>> and Left (RecordType,2) # 'AP' ; >>> into Cursor C_Detail>>>So, how can I speed this up?
>>Select * From KTrackTagDetail ; >> left join C_Kits on ( KTrackTagDetail.Seqno == C_Kits.Seqno ) ; >> or ( KTrackTagDetail.SeqnoFG == C_Kits.Seqno ) ; >> where ( Left (RecordType,2) # 'AP' ) ; >> and ( C_Kits.Seqno is not null ) >>>