group by problem
Hej EksperterJeg har den her:
SELECT WebWebpages.ID, WebWebpages.PID, COUNT(WebWebpages.Active) AS counter
FROM WebWebpages INNER JOIN
WebLayouts ON WebWebpages.LayoutID = WebLayouts.ID
WHERE (WebWebpages.Startdate IS NULL OR
WebWebpages.Startdate <= GETDATE()) AND (WebWebpages.Enddate IS NULL OR
WebWebpages.Enddate >= GETDATE()) AND (WebWebpages.WebhotelID = 1) AND (WebWebpages.Active = 1) AND (WebWebpages.PID = 15)
GROUP BY WebWebpages.PID, WebWebpages.ID
min COUNT(WebWebpages.Active) AS counter skal give resultatet 11 men giver mig istedet 11 gange 1. Hvis jeg fjerner id og pid fra min select og fjerner group by clausulen så giver den rigtig nok 11.
Hvad kan jeg gøre for at få det rigtige resultat og bibeholde id og pid i min select.
