SELECT distinct maker,instrument FROM horns where maker="Pihan" order by Maker,Instrument
Listing for Pihan
Instrument:
Alto Horn
Cornet
Fluglehorn
Mellophone
Trumpet
Return
