>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?
>
>Thanks


or
This could also work

Select * From KTrackTagDetail ;
	left join C_Kits on ( C_Kits.Seqno in ( KTrackTagDetail.Seqno, KTrackTagDetail.SeqnoFG) ) ;
	where (  Left (RecordType,2) # 'AP' ) ;
	    and ( C_Kits.Seqno is not null )