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