SQL query question

[Ruslan Zasukhin]

on 2/13/04 1:34 AM, Charles Yeomans at yeomans at desuetude.com wrote:

>> IF you search childs of just ONE record,
>> Then I think you can ask only ONE table on BETWEEN
>> 
> 
> Indeed I can.  But what I really want is to do aggregate reports and
> that does seem to require SQL of the sort I gave.  Of course I can
> build my reports using SQL plus some Rb programming.

Again,

Try 

May be you need to use

    fld IN SUBSELECT

For you task



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