SELECT distinct maker,instrument FROM horns where maker="Missenharter" order by Maker,Instrument
Listing for Missenharter
Instrument:
Alto Horn
Ballad Horn
Cornet
Euphonium
Euphonium; DB
Sousaphone
Trombone
Trombone; AltoV
Trombone; Valve
Trumpet
Tuba
Return