scusa ho sbaglaito link,prova così:
SELECT tblItems.ID, COUNT(tblItems.ID)
FROM tblItems INNER JOIN tblCommenti ON tblItems.ID = tblCommenti.IDItem
GROUP BY tblItems.ID
ORDER BY COUNT(tblItems.ID)
scusa ho sbaglaito link,prova così:
SELECT tblItems.ID, COUNT(tblItems.ID)
FROM tblItems INNER JOIN tblCommenti ON tblItems.ID = tblCommenti.IDItem
GROUP BY tblItems.ID
ORDER BY COUNT(tblItems.ID)
Permessi di invio
Rispondi quotando