Something

SELECT     Trackclearance_wizzard_tracks.TrackName, Trackclearance_wizzard_tracks.MixName, Trackclearance_wizzard_tracks.ArtistName, 
                      Trackclearance_wizzard_tracks.LabelName, Trackclearance_wizzard_compilations.TempCompilationName AS CompilationName, 
                      Trackclearance_wizzard_tracks.Status, Trackclearance_wizzard_tracks.UsedInMix, Trackclearance_wizzard_tracks.NewestHoaID
FROM         Trackclearance_wizzard_tracks INNER JOIN
                      Trackclearance_wizzard_HOAs ON Trackclearance_wizzard_tracks.NewestHoaID = Trackclearance_wizzard_HOAs.ID INNER JOIN
                      Trackclearance_wizzard_compilations ON 
                      Trackclearance_wizzard_tracks.Trackclearance_wizzard_compilation_id = Trackclearance_wizzard_compilations.ID
WHERE     (Trackclearance_wizzard_tracks.TrackName LIKE '%sha%')