SQL Query - Please guide

Question

Dear all,

I am again stuck up in making SQL Select Query…

Please guide…

SQL Server Structure

TBLCity

ID	CityName
1	Mumbai
2	Navi Mumbai
3	Thane
4	Pune
5	Latur

TBLLocations

ID	CityID (Foreign Key for TBLCity)	Area
1	2	Airoli Sector-15
2	2	Ghansoli Naka
3	2	Kharghar
4	3	Kalyan
5	3	Ambarnath
6	3	Bhiwandi
7	4	Haveli Taluka
8	4	Bhor
9	4	Baramati
10	1	Dadar
11	1	BKC(Bandra-Kurla Complex)

Select

(select city.CityName from TBLCity city where city.ID = locations.CityID),

locations.Area

 from TBLLocations locations

This gives output as –

CityID (Foreign Key for TBLCity)	Area
Navi Mumbai	Airoli Sector-15
Navi Mumbai	Ghansoli Naka
Navi Mumbai	Kharghar

But now, I need the output as –

Mumbai- Dadar, BKC(Bandra-Kurla Complex)

Thane-Kalyan,Ambernath

How do I get this output ?

Please guide