Hi,

Any tips on how can I get all rows given the following example?

Table:
Instruments (contains instruments I own)

Records:
Piano
Guitar
Keyboard
Flute
Violen

Table:
Songs (a library of all my songs)

Records:
Paradise City (id 1)
Back In Black (id 2)

Table:
Instruments_In_Song (rows for each instrument in each song from above
table)
Guitar (song_id 1)
Keyboard (song_id 1)
Guitar (song_id 2)
Drums (song_id 2)

Forget about the accuracy of the actual example. What I want is to find
all songs that have instruments that I own. In the example above, the
query would include Paradise City since I have a guitar and a keyboard,
but would omit Back in Black since I have a guitar, but don't have a
drum set.

Any pointers with SQL would be helpful.

Thank you,

Michael