COUNT() und mehrere Tabellen

[Ralf Eggert]

Hallo,

>SELECT news.id, COUNT(emitted) AS emitted FROM news, emitted_news
>left joine news.id = emitted_news.id GROUP BY news.id ORDER BY updated
>DESC

richtig sollte es so heissen:

SELECT news.id, COUNT(emitted) AS emitted 
FROM news
LEFT JOIN emitted_news
ON news.id = emitted_news.id
GROUP BY news.id
ORDER BY updated

Gruss,

        Ralf

-- 
__________________________________________
 In-Greece.de - die Griechenlandcommunity
_______ http://www.in-greece.de/ _________

---
!!NEU!!
Fragen und Antworten zu MySQL und dieser Liste unter
-->>  http://www.4t2.com/mysql