sql speed

[Ruslan Zasukhin]

On 2/27/05 11:28 AM, "jda" <jda at his.com> wrote:

>> 
>> 
>> 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)

No, how you get original list of recIDs?

Using some SQL query ?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------