okay, let me run through the logic of your query as it is currently written
you want album and artist data for all albums where the album was done by a specific artist OR where there exists a track on the album which was done by the same artist? like in a collection of chrismas hits by various artists?
if i understand this correctly, then you can do it like this --
note that UNION eliminates duplicates, which i think might come about because the artist's fullname is likely going to also be on all tracks where he's the artist on the album
select tblAlbums.Title as title
, tblAlbums.MediaType as format
, tblAlbums.AlbumID as albumid
, tblArtists.The as artist_the
, tblArtists.Artist as artist
, tblArtists.ArtistID as artistid
, tblArtists.SortName as sortname
where tblArtists.Artist like '%Willie Nelson%'
where tblTracks.ArtistFullName like '%Willie Nelson%'