On 5/31/04 12:46 PM, "olivier" <vidal_olivier /at/ yahoo .D.OT 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@paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------
_______________________________________________
Valentina mailing list
Valentina /at/ lists .D.OT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2004 Ruslan Zasukhin |
