sql strange, VSTUDIO and V4MD 4.3

[Christian - ChrisKatDev.com]

Hello,

I have this request :
SELECT t1.idScrap, (t1.pertinence + t2.pertinence) as s FROM kw_in_scrap as t1, kw_in_scrap as t2 WHERE (t1.kw = 'musique' and t2.kw = 'cuivre' and t1.idScrap = t2.idScrap) ORDER BY s DESC

but I have wrong values for s in the results and I don't know why.

Example :
idscrap, kw, pertinence
1, musique, 1
1, cuivre, 0.25
1, son, 0.5
2, musique, 1
2, bruit, 0.25
2, cuivre, 0.3333

I want to have :
idscrap, s
1, 1.25
2, 1.3333

but I have
2, 0.6666
1, 0.5

An idea ?

second problem : in Director, order by s is ignored and Valentina make an order by recid in fact...

a second idea ?

br
Christian