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