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
Hi there,
I have a table containing my CD collection information, the simplified
structure is following:
id artist album
1 A.R.T The best of A.R.T
2 ATB Big Hits Collection
3 A.R.T My Artistic Life
4 A.R.T You are the only one
How can I build up a query that will contain all
