I am trying to get just the members of a group using an SQL query. I managed to link via the foreign keys entity0 and entity1 of l_artist_artist, however I am getting all relationships. How can I get just the band members pls?
SELECT a.name,c.name from l_artist_artist
JOIN artist a ON l_artist_artist.entity0=a.id
JOIN artist c ON l_artist_artist.entity1=c.id
where c.name = ‘The Beatles’