Will thumbs up if can help. Using MySQL Delete all members associated with the artist 'Sonata' from the Members2 table. Pics on all tables provided. --Note: Members and artists are connected through Member id/artists id. See Table picture. (Members with ID #7,8,9 are the ones being deleted) --Let me know if you have any questions

mysql> show tables; | Tables_in_lyrics I |artists genre members |members2 | salespeople | studios | titles | tracks | xrefartistsmembers | 9 rows in set (0.00 sec) mysql> select* from xrefartistsmembers; | MemberID | ArtistID | RespParty | 20 31 2 14 10 13 32 19 21 34 29 15 35 14 15 15 15 17 17 10 10 10 16 16 18 18 18 26 18 28 30 36 23 rows in set (0.01 sec)