[V4MD] VERY Weird result

[Ruslan Zasukhin]

on 7/11/03 13:05, Gregoire William at wgregoire at paris.mediagerance.com
wrote:

> I don't understand why
> 
> WHERE Produit.IdMarque = 9 AND PubM.IdProduit = Produit.IdProduit AND
> PubM.Hide = 0 AND Produit.Prestige = 1 AND Produit.AllAbout = 1
> 
> give a erroneous result (like if IdMarque = 9 was here)
> 
> and
> 
> WHERE PubM.IdProduit = Produit.IdProduit AND PubM.Hide = 0 AND
> Produit.IdMarque = 9 AND Produit.Prestige = 1 AND Produit.AllAbout = 1
> 
> give a good result....

Valenitna 1.x require from you one rule:

    all conditions for one table should be grouped together.

The search clause should looks as

    WHERE 
        (T1.id = T2.ptr and T2.id = T3.ptr and ... )
      AND
        (T1.f1 = a and T1.f2 = b and ... )
      AND/OR
        (T2.f1 = w and ...)


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