I have two tables: for example
Customer Information
-------------------------
Name
Favorite Color ID

Color
--------
Favorite Color ID
Color


How can I display all customer names grouped by favorite color in this manner


Blue

Tom
Frank
Jim

Green

Sally
Mike
John

thanks for your help

what db are you using> Let me know and I will post the sql you need.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting