SELECT distinct maker,instrument FROM horns where maker="Hamm" order by Maker,Instrument
Listing for Hamm
Instrument:
Tenor Horn
Return