> > >Hi Jon, > >New is sub-select (actually form that you need was in the 1.x also). > >Select >>From T1 >WHERE recid in (select recid from T2 .... ) > Sorry to be stupid, but I only have one table. At the point of the final query I have an array of recid's, say 2000. Are you saying the query should be Select * from T1 WHERE 1,4,6,12,14... in (select recid from T1) Jon