SQL Server - how to select each data from table ?

Hi frndz!

I am doing project in MSSQL 2008 . In my project i have to take each data separately from table and have to show.

For eg there are 2 table:

Area table (In this Area table below are the datas)
1.area
2.street
3.rode

AreaType table(In this AreaType table below are the datas)

1.che
2.bng
3.try

based on area table area type has to show in bulleted list

there is one text area in the screen. In the screen display should be like this:

area

•    che
•    bng

street

•     try
•     che

rode

•     bng

so whatever area having their area type have to display in above format. so give the code with detail explanation
Thanks frndz.

u cannot do that in sql ,mabe in c sharp we can add a list type,and use database to populate the data in the list box