AN ALLE bitte LESEN !!!

[Ilja]

yo,

ohne gewähr wie immer und eventuelle folgende korrekturen:

SELECT man_nr,
SUM(IF((man_nr = sp_heim AND sp_h_t > sp_g_t) OR (man_nr = sp_gast AND sp_h_t < sp_g_t), 1, 0)) AS Gewonnen,
SUM(IF((man_nr = sp_heim AND sp_h_t < sp_g_t) OR (man_nr = sp_gast AND sp_h_t > sp_g_t), 1, 0)) AS Verloren,
SUM(IF(sp_h_t = sp_g_t, 1, 0)) AS Unentschieden,
SUM(IF(man_nr = sp_heim, sp_h_t, 0)) + SUM(IF(man_nr = sp_gast, sp_g_t, 0)) AS Tore,
SUM(IF(man_nr <> sp_heim, sp_h_t, 0)) + SUM(IF(man_nr <> sp_gast, sp_g_t, 0)) AS Gegentore,
SUM(IF(man_nr = sp_heim, sp_h_t, 0)) + SUM(IF(man_nr = sp_gast, sp_g_t, 0)) -
SUM(IF(man_nr <> sp_heim, sp_h_t, 0)) - SUM(IF(man_nr <> sp_gast, sp_g_t, 0)) AS Tordifferenz,
COUNT(*) AS Spieleanzahl
FROM manschaft AS m LEFT JOIN spiel AS s ON (m.man_nr = s.sp_heim OR m.man_nr = s.sp_gast)
GROUP BY man_nr
ORDER BY 2 DESC, 4 DESC, 7 DESC

Ilja