SQL frustrations

[Ruslan Zasukhin]

on 2/11/04 6:01 PM, Robert Brenstein at rjb at rz.uni-potsdam.de wrote:

>> 2) in the WHERE you should group fields of the same table together
>> 
>>         (T1.f1 and T1.f2 and T1.f ... )
>>     and
>>         (T2. And or T2 ... )
> 
> And what is the order if I have fields from 3 or 4 tables having pair
> comparisons between each two? There is no way to group the queries
> together as I see.

That are LINK CONDITIONS


    FROM T1, T2, T3, T4
    WHERE 
        T1.id = T2.ptr and T2.id = T3.ptr and T3.id = T4.ptr
    AND
       // now we list SEARCH CONDITIONS:
         (T1.f1 and T1.f2 and T1.f ... )
     and
         (T2. And or T2 ... )



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