How about this: SELECT DISTINCT c.name AS artist, a.title AS album FROM contributors c, albums a, contributor_album ca WHERE c.id=ca.contributor AND (ca.role=1 or ca.role=5) AND a.id=ca.album and (a.compilation IS NULL OR a.compilation=0) UNION SELECT DISTINCT 'Various Artists', a.title FROM albums a WHERE a.compilation=1 ORDER BY artist, album
Note that I've included album artists (aka Band) role=5 -- smc2911 ------------------------------------------------------------------------ smc2911's Profile: http://forums.slimdevices.com/member.php?userid=4388 View this thread: http://forums.slimdevices.com/showthread.php?t=29282 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss