SELECT distinct maker,instrument FROM horns where maker="Krumphanzl" order by Maker,Instrument
Listing for Krumphanzl
Instrument:
French Horn
Trumpet
Return