Code: Select all
SELECT Songs.ID, timesPlayed
FROM Songs, [SELECT Played.idSong as SID, Count(Played.idSong) AS timesPlayed FROM Played GROUP BY Played.idSong]. AS subq
WHERE Songs.Id =subq.SID;
Any ideas?
Pablo
Code: Select all
SELECT Songs.ID, timesPlayed
FROM Songs, [SELECT Played.idSong as SID, Count(Played.idSong) AS timesPlayed FROM Played GROUP BY Played.idSong]. AS subq
WHERE Songs.Id =subq.SID;