SELECT TeamA,1 as SortCol FROM Under11s UNION SELECT TeamB,2 as SortCol FROM Under11s order by SortCol,TeamB
--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters