[V4MD] VERY Weird result

[Gregoire William]

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


EVEN weird, if i delete the Produit.prestige = 1 in the first request, all
is ok...

I tested with a lot of "()", nothing better...

Does it mean the where condition must be written grouped by table ?!?!

CrrCrr