Select KTrackTagDetail.* From KTrackTagDetail ; Join C_Kits On KTrackTagDetail.Seqno = C_Kits.Seqno ; where Not KTrackTagDetail.RecordType Like 'AP%' ; ; union ; ; Select KTrackTagDetail.* From KTrackTagDetail ; Join C_Kits On KTrackTagDetail.SeqnoFG = C_Kits.Seqno ; where Not KTrackTagDetail.RecordType Like 'AP%' ; ; into Cursor C_Detail>The following is very slow, presumably because of my use of IN
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?