---
title: "COUNT() - Visa 0"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/92498-count-visa-0"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Mr.Switch"
published: "2003-12-12T13:47:23.000Z"
updated: "2003-12-12T13:56:15.000Z"
replies: 2
views: 308
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/92498-count-visa-0"
---

# COUNT() - Visa 0

## #1 — Mr.Switch, 2003-12-12T13:47Z

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

Permalänk: https://www.webforum.nu/p/92498

## #2 — LarsG, 2003-12-12T13:52Z

```
FROM tblLaginfo a left outer join tblSpeladeMatcher b
on a.sLagID = b.sLagID
WHERE a.sSerieID = '7'
ORDER BY a.sPoints DESC
```

Permalänk: https://www.webforum.nu/p/1227708

## #3 — Mr.Switch, 2003-12-12T13:56Z

Helt otroligt!!!

Permalänk: https://www.webforum.nu/p/1227710

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/92498-count-visa-0