Are there a way how you can combine two data columns in a listbox in Asp.net and set the background color for the main column, for example the two columns are Town and Suburb, I am trying to combine them with the main Column "Town" and then his Suburbs and then the second Town and then his Suburbs like the following Town1 Suburb1 Suburb2 Suburb3 Town2 Suburb1 Suburb2 Suburb3 Town3 Suburb1 Suburb2 Suburb3 Please help I went through a few Sql books already. Samuel G

Hi,I want to display two columns from one table in a Web Form dropdownlist,I've tried something like this @"SELECT TeamA FROM Under11s. UNION SELECT TeamB FROM Under11s;"; But the result set mixes the columns I want them grouped together like "TeamA" Player1 Player2 Player3 "TeamB" Player1 Player2 Player3 SQl Server Or MySql. Flip Gabes