Or, even better, select distinct contributors.name , albums.title from contributors , albums , contributor_album where contributors.id=contributor_album.contributor and contributor_album.role=1 and albums.id=contributor_album.album order by contributors.name, albums.title
... which additionally selects only "artist" contributors, stops cluttering the list with composers and conductors which you may have listed... Ceejay -- ceejay ------------------------------------------------------------------------ ceejay's Profile: http://forums.slimdevices.com/member.php?userid=148 View this thread: http://forums.slimdevices.com/showthread.php?t=29282 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
