If every album had one or more contributors with albumartist roles, generating an album list should be doable in a single query by using the group_concat() function. The following query would generate a full list of albums sorted by artist/year/title, with all album artists for each.
ooh... ah.... group_concat - nice one! Didn't know this function. While I won't go all the way you describe just yet, that function will simplify my current change. Thanks for the hint! More next week.
-- Michael _______________________________________________ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
