my $sth = $dbh->prepare("SELECT aqbooksellerid, aqbooksellers.name
FROM subscription
LEFT JOIN aqbooksellers ON (subscription.aqbooksellerid=aqbooksellers.id )
GROUP BY aqbooksellers.id
ORDER BY aqbooksellers.name ASC
");
$sth->execute();
-