- shows (id, date, venue, city, state, length, source, source2, rating)
- songs (id, name)
- shows_songs (shows_id, songs_id)
I want to be able to query the shows table and display all the songs from that show. I also want to query the songs table and display all the shows where that song appears.
shows table has 2 shows. 3 songs played at each show.
songs table has 5 songs. Some of those songs were played at show1. some at show2. some at both
show1 setlist: song1, song2, song3
show2 setlist: song2,song4, song5
Do I need a FK in one of these tables? How would that look? Or can this be done with joins? I am not too clear on that either.
Thanks for your help and suggestions