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 )