SELECT distinct maker,instrument FROM horns where maker="Preisinger" order by Maker,Instrument
Listing for Preisinger
Instrument:
Fluglehorn
Trumpet
Return