Hi,
Sun, 17 Aug 2003 20:08:43 +0300 tarihinde Ville Mattila
<[EMAIL PROTECTED]> soyle yazdi:
VM> I've already tried this
VM> SELECT DISTINCT mh.*, COUNT(mh2.id) AS albumsofartist FROM cd.mh,
VM> cd.mh2 WHERE mh.artist= mh2.artist GROUP BY mh2.artist
VM> But it dosen't give correct results.
Try with COUNT(DISTINCT mh2.id)
Doruk
--
FISEK INSTITUTE - http://www.fisek.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
