sql med inner join liten feil et sted!
//Denne virker helt fint men når jeg skulle bytte ut WPLanguageFKLocalID med LocaleID som hentes i tblWPLocale så ble det feil noen data kom korrekt:SELECT
DISTINCT WPLanguageID,WPLanguage,WPLanguageFlag,WPLanguageFKLocalID,COUNT(DISTINCT NewsID) AS AntallNews, COUNT(DISTINCT 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
Blir:
1 Norsk no.gif 86 12 30
2 Engelsk gb.gif 85 2 0
3 Romaniansk ro.gif 84 0 0
SELECT
DISTINCT tblWPLanguage.WPLanguageID,tblWPLanguage.WPLanguage,tblWPLanguage.WPLanguageFlag,tblWPLocale.LocaleID,COUNT(DISTINCT tblWPNews.NewsID) AS AntallNews, COUNT(DISTINCT tblWPDocuments.DocID) AS AntallDocs
FROM tblWPLanguage
LEFT JOIN tblWPNews ON (tblWPLanguage.WPLanguageID=tblWPNews.NewsFKWPLanguageID)
LEFT JOIN tblWPDocuments ON (tblWPLanguage.WPLanguageID=tblWPDocuments.DocFKWPLanguageID)
LEFT JOIN tblWPLocale ON (tblWPLocale.LocalID = tblWPLanguage.WPLanguageFKLocalID)
GROUP BY tblWPLanguage.WPLanguageID,tblWPLanguage.WPLanguage,tblWPLanguage.WPLanguageFlag,tblWPLocale.LocaleID
Blir:
3 Romaniansk ro.gif 1048 0 0
1 Romaniansk ro.gif 1049 12 30
2 Romaniansk ro.gif 2072 2 0
Hva er feil? ID, localeid og counts er riktig men ikke WPLanguage og WPLanguageFlag.....
//Morten
