FROM tblLaginfo a left outer join tblSpeladeMatcher b
on a.sLagID = b.sLagID
WHERE a.sSerieID = '7'
ORDER BY a.sPoints DESC
Trådstart#1
SELECT a.sLagNamn,
(SELECT COUNT(*) FROM tblSpeladeMatcher WHERE sLagID = a.sLagID) AS Matcher,
(SELECT COUNT(*) FROM tblVunnaMatcher WHERE sLagID = a.sLagID) AS VunnaMatcher,
(SELECT COUNT(*) FROM tblOavgjordMatcher WHERE sLagID = a.sLagID) AS OavgjordaMatcher,
(SELECT COUNT(*) FROM tblForloradeMatcher WHERE sLagID = a.sLagID) AS ForloradeMatcher,
(SELECT SUM(sGoal) FROM tblPlusGoal WHERE sLagID = a.sLagID) AS PlusGoal,
(SELECT SUM(sGoal) FROM tblMinusGoal WHERE sLagID = a.sLagID) AS MinusGoal,
((SELECT SUM(sGoal) FROM tblPlusGoal WHERE sLagID = a.sLagID) - (SELECT SUM(sGoal) FROM tblMinusGoal WHERE sLagID = a.sLagID)) AS GoalDiff,
a.sPoints
FROM tblLaginfo a, tblSpeladeMatcher b
WHERE a.sSerieID = '7'
AND a.sLagID = b.sLagID
ORDER BY a.sPoints DESC
Denna fina kodsnutt tar fram en tabell. Detta funkar fint, men den vill inte visa vilka lag som inte har spelat någon match.
Ideér är varmt välkomna.
// Mr.Switch