Predmet:Re:Više counta u jednom upitu

---

Uspeo sam pomoću leftjoin ali za dva reda,pa me zanim kako da postavim i treći...Evo ga kod:

SELECT q1.rm, q1.Ukupno AS Cod1, q2.Ukupno1 AS Cod2
FROM [SELECT DISTINCT posta.rm, Count(posta.rm) AS Ukupno
FROM posta
WHERE (((posta.[9])="6,4" Or (posta.[9])="6.4" Or (posta.[9])="6,40" Or (posta.[9])=" 8" Or (posta.[9])="8,0" Or (posta.[9])="8.0" Or (posta.[9])="7" Or (posta.[9])="7,0" Or (posta.[9])="7.0"))
GROUP BY posta.rm
]. AS q1 LEFT JOIN [SELECT DISTINCT posta.rm, Count(posta.rm) AS Ukupno1
FROM posta
WHERE [9]="Go"
GROUP BY posta.rm
]. AS q2 ON q1.rm = q2.rm;

Treća bi trebala da bude kao i druga samo umesto go,da bude bo...ovako

SELECT DISTINCT posta.rm, Count(posta.rm) AS Ukupno1
FROM posta
WHERE [9]="Bo"
GROUP BY posta.rm
]. AS q2 ON q1.rm = q2.rm;