Hi, thank for your work on this! I wonder if I can assoicated an object by an id to another corresponding object during iteration. i.e. Getting the object A, B during the iteration by inner join. // ...
SELECT a2.ArtistId, a2.Name, count(*) as Records from Album a INNER JOIN Artist a2 GROUP BY 1; SELECT a2.ArtistId, a2.Name, count(*) as Records from Album a INNER JOIN Artist a2 GROUP BY 1 ORDER BY ...