Hi,<br><br>I'm trying to run a report that gives me a list of the most popular DVDs for the current month. When I run the report, I get a list of DVDs that all have an issue count of one,(which I know is not the case). And when I look at the checkout history for DVDs that I know are popular - some don't appear on the list at all, and all have an issue count much higher than one for that time period. <br>
Any ideas/help would be much appreciated<br>
<br>SELECT biblio.title,biblio.author,COUNT(*) AS issuecount FROM issues,biblio,items WHERE items.biblionumber = biblio.biblionumber AND issues.itemnumber= items.itemnumber AND issues.issuedate > '2010-02-28' AND items.itype='DVD' GROUP BY biblio.biblionumber ORDER BY issuecount DESC LIMIT 20<br>
<br>thanks<br>Sharon<br>
<br clear="all">
<br>--<br>Sharon Jackson<br>Librarian RLIANZA<br>Albany Senior High School<br>
P O Box 300-380<br>Albany 0752<br>Phone. (09)451 9065<br>Fax. (09)451 9209<br>Mobile 021 020 60451<br><br>