More Help Plz

From: Mumblez <mumblez2002_at_btinternet.com>
Date: Mon, 3 Nov 2003 01:59:09 +0000 (UTC)
Message-ID: <bo4cpd$gvv$1@titan.btinternet.com>

sorry need some more help, i have a table with group members names and one of them is the group leader, i have 5 groups and wish to display them with the group leader at the top and the members of the group below them in aphabetical order

for example

leader                        group members
0001                            bill bloggs
                                    bill adams
                                    dave collins
                                    peter smith
0002                            john mason
                                    steve bassett
                                    mike french
                                    donna welsh
0003                            brian phillips
                                    bill hadley
                                    martin taylor

get the idea...............any help with the sql will be greatly appreciated

Thank you Received on Sun Nov 02 2003 - 19:59:09 CST