2 counts i samme spørring
Jeg har 2 spørringer som jeg vil ha i en:SELECT DISTINCT
WPLanguageID,WPLanguage,WPLanguageFlag,WPLanguageFKLocalID,
COUNT(DocID) AS AntallDoc
FROM tblWPLanguage
LEFT JOIN tblWPDocuments ON tblWPLanguage.WPLanguageID=tblWPDocuments.DocFKWPLanguageID
GROUP BY WPLanguageID,WPLanguage,WPLanguageFlag,WPLanguageFKLocalID
SELECT DISTINCT
WPLanguageID,WPLanguage,WPLanguageFlag,WPLanguageFKLocalID,
COUNT(NewsID) AS AntallNews
FROM tblWPLanguage
LEFT JOIN tblWPNews ON tblWPLanguage.WPLanguageID=tblWPNews.NewsFKWPLanguageID
GROUP BY WPLanguageID,WPLanguage,WPLanguageFlag,WPLanguageFKLocalID
Dette virker ikke:
SELECT DISTINCT
WPLanguageID,WPLanguage,WPLanguageFlag,WPLanguageFKLocalID,
COUNT(NewsID) AS AntallNews,
COUNT(DocID) AS AntallDocs
FROM tblWPLanguage
LEFT JOIN tblWPNews ON tblWPLanguage.WPLanguageID=tblWPNews.NewsFKWPLanguageID
LEFT JOIN tblWPDocuments ON tblWPLanguage.WPLanguageID=tblWPDocuments.DocFKWPLanguageID
GROUP BY WPLanguageID,WPLanguage,WPLanguageFlag,WPLanguageFKLocalID
