SUM Permutationsproblem

[Peter Schmidt]

Hallo zusammen,

irgendwie bekomme ich bei der Berechnung einer Summe -SUM( tw4.i40309 + tw3.i30407 ) - die falschen Werte und habe keine Anhnung warum.Idee was falsch sein könnte. Die SQL Abfrag generiert sich dynamisch.

Wenn ich diese Tabelle ausblende sdw2_oid_rid_oname o, sdw2_hid_oid_hname h,sdw2_lid_kid_lname l berechnet er richtig.

Danke vorab - Gruss Peter

SELECT region, 1 * wera +1 * summe AS rank, land
FROM (

SELECT tw3.rid AS region, SUM( tw4.i40309 + tw3.i30407 ) AS summe, SUM( tw4.wera + tw3.wera ) AS wera, r.lid AS land

FROM sdw2_tregio_spo tw4, sdw2_tregio_spa tw3, sdw2_lid_kid_lname l, sdw2_rid_lid_rname r, sdw2_oid_rid_oname o, sdw2_hid_oid_hname h

WHERE l.lid = r.lid
AND r.rid = o.rid
AND o.oid = h.oid
AND r.rid = tw3.rid
AND LEAST( i40309, i30407, 1 ) >0
GROUP BY tw3.rid
ORDER BY summe DESC
LIMIT 1000
)sub, sdw_regis
WHERE region = rid
ORDER BY rank DESC
LIMIT 0 , 30



Edited 1 time(s). Last edit at 11/28/2012 02:53PM by Peter Schmidt.