Group Itens With MSSQL and Classic ASP

vickyrandhawa

New Member
I have the following table:\[code\]Name Type Color PlaceAna A Blue AmericaSandra A Red IndiaMary A Red AmericaPaige B Orange AfricaFox B White AfricaJohn C Black Mexico\[/code\]I would like to group the itens by type and show, like this:\[code\]Type AAna - Blue - AmericaSandra - Red - IndiaMary - Red - AmericaType BPaige - Orange - AfricaFox - White - AfricaType CJohn - Black - Mexico\[/code\]What kinda of loop will help me with this?Thanks!
 
Back
Top