Hello.
I am trying to understand how to solve a problem I have run across involving self-referential tables. The table stores the name and various relevant details about musical artists. One detail I want to be able to list is the artist's influences. The artist's influences are themselves artists. And, any one artist can have several influences.
I am at a loss, how can I best approach this problem?

Use table alias, joins etc.