As far as I can see, this can't be done in MJ. Please enlighten me if I'm wrong (I hope I am).
Being an anal pedant (like so meny MJ users), I store the correct artist details for every track. This causes a bit of a problem for Artist/Album type view schemes. The Artist list quickly becomes dominated by obscure names from countless compilation albums.
I want to create a view scheme that includes Artists only if I have one of their albums. So I want a scheme that shows all tracks by Artist for whom I have an album but includes their tracks from compilation albums as well.
For the technically minded, it's simpler to describe in SQL:
SELECT *
FROM Library
WHERE Artist IN
( SELECT Albumartist
FROM Library
WHERE Albumartist NOT= "Various Artists")
Listening to: 'All That Jazz' from 'Best Of Ute Lemper, The' by 'Ute Lemper' on Media Jukebox