Set artist as the left table and notice that 3, Bill Evans still appears in the results, despite not having a match.
artist
3, Bill Evans
Make sure to type FROM artist.
FROM artist