What does this query select?

All artist items and any matching album itemsOnly artist items that have a match in the album table

All artist items and any matching album items.