SELECT distinct maker,instrument FROM horns where maker="Nordheimer" order by Maker,Instrument
Listing for Nordheimer
Instrument:
Cornet
Return