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