Member Avatar for kapu

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?

  • 2 Contributors
  • 1 Reply
  • 43 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

Use table alias, joins etc.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.