Re[2]: Nochmal Hitliste

[Malte Schomers <mschomers_(at)_gmx.de>]

Hi!

Cyrill Schumacher <webmasterbhs_(at)_bluewin.de> schrieb:
> select a.Autoren as aa,distinct(b.AutorID) as dba,count(b.AutorID) as cba
>>from Autoren as a, Artikel as b
> where a.ID = b.AutorID
> group by dba
> order by cba asc
Hi!

So leid es mir tut, ich kriege folgenden Fehler:

MySQL meldet: You have an error in your SQL syntax near 'DISTINCT(b.Autor) as dba, COUNT(b.Autor) as cba from Members as a, Artikel as b ' at line 1

Malte
-- 
[ - - - - - - - - - - - - - - - - - - - - - - - - - - ]
[ malte schomers | mschomers_(at)_gmx.de | www.malte.de.cx ]
[ icq#: 39453721 | odigo id: 202551 ->  www.odigo.com ]
[ - - - - - - - - - - - - - - - - - - - - - - - - - - ]


---
*** Abmelden von dieser Mailingliste funktioniert per E-Mail
*** an mysql-de-request_(at)_lists.4t2.com mit Betreff/Subject: unsubscribe