bad result SQL

[Ruslan Zasukhin]

On 5/31/04 12:46 PM, "olivier" <vidal_olivier at yahoo.fr> wrote:

> hi,
> 
> The result of my request SQL is different according to the place of
> columns in the request.
> It is normal?

Hi oliver,

In Valentina 1.x you should follow rule:

    group fields of the same table together.

NEVER do this

    WHERE T1.f = 5 and T2.f = 6 and T1.f2 > 7
                                    ^^^^^^^^
                                    T1 go after 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
-------------------------------------------------------------