@@ -, +, @@ alphabetically - First: ZZZZ - Second: AAAA --- reports/serials_stats.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) --- a/reports/serials_stats.pl +++ a/reports/serials_stats.pl @@ -138,7 +138,8 @@ if($do_it){ my $sth = $dbh->prepare("SELECT aqbooksellerid, aqbooksellers.name FROM subscription LEFT JOIN aqbooksellers ON (subscription.aqbooksellerid=aqbooksellers.id ) - GROUP BY aqbooksellerid"); + ORDER BY aqbooksellers.name ASC + "); $sth->execute(); while(my $row = $sth->fetchrow_hashref){ --