How to use a join and then sort the data

[#1]

Name	Status	City
Amit Prabhu	Maharashtra	Thane
Narayan Nihalani	Maharashtra	Thane
Rameez Shaikh	Maharashtra	Mumbai
Deepak Soni	Maharashtra	Mumbai
Muzammil Ansari	Maharashtra	Mumbai
Sandeep Patwa	Maharashtra	Mumbai

Region	City
West	Thane
West	Mumbai
East	Mumbai
South	Mumbai
North	Thane
North	Nashik

How can we join this tables using joins and then sort according to the Region.

eg. all city with thane should come together and then Mumbai and so on.

[Anil_Babu_Samineni]

What you want to see from UI. Can you let me know the expected to see

[muthukumar77]

Names:

LOAD * INLINE [

    Name, Status, City

    Amit Prabhu, Maharashtra, Thane

    Narayan Nihalani, Maharashtra, Thane

    Rameez Shaikh, Maharashtra, Mumbai

    Deepak Soni, Maharashtra, Mumbai

    Muzammil Ansari, Maharashtra, Mumbai

    Sandeep Patwa, Maharashtra, Mumbai

];

Left Join(Names)

LOAD * INLINE [

    Region, City

    West, Thane

    West, Mumbai

    East, Mumbai

    South, Mumbai

    North, Thane

    North, Nashik

];

NoConcatenate

Final:

LOAD Name,Status,City,Region Resident Names Order by Region asc;

DROP Table Names;

Can you ask like this?

[#4]

  Table 1  

Region	City
West Th	West  Thane
West Mu	West  Mumbai
East Mu	East  Mumbai
South Mu	South  Mumbai
North Th	North  Thane
North Na	North  Nashik
West Na	West  Nashik
East Na	East  Nashik
South Na	South  Nashik
West Na	West  Nagpur
North Na	North  Nagpur
West Pu	West  Pune
East Pu	East  Pune
South Pu	South  Pune
North Mu	North  Mumbai
South Th	South  Thane
North Pu	North  Pune
East Th	East  Thane
West Ra	West  Raigad
North Ra	North  Raigad
North Ah	North  Ahmedabad
West Ah	West  Ahmedabad

  Table 2  

Name	Mobile	Status	Region
Amit Prabhu	9820261173	Maharashtra	West Th
Narayan Nihalani	9324764624	Maharashtra	West Mu
Rameez Shaikh	9930038445	Maharashtra	East Mu
Deepak Soni	8080106009	Maharashtra	South Mu
Muzammil Ansari	9892964447	Maharashtra	North Th
Sandeep Patwa	9222337250	Maharashtra	North Na
Warish Hashmi	9699446027	Maharashtra	West Na
Sarfaraz Ansari	8080220160	Maharashtra	East Na
Somnath Birajdar	9220588835	Maharashtra	South Na
Saish Wagle	8983915333	Maharashtra	West Na
Shaeque Khan	9987700440	Maharashtra	North Na
Paresh Kawa	9930583258	Maharashtra	West Pu
Abdul Kayyum  Shaikh	9920290489	Maharashtra	East Pu
Sarfaraz Mirza	9930884114	Maharashtra	South Pu
Abdul Aamir  Shaikh	9545778881	Maharashtra	North Mu
Jiten Gala	7666555055	Maharashtra	South Th
Salman Imran Kadiwal	9819852367	Maharashtra	North Pu
Rupesh Pawar	9220360005	Maharashtra	East Th
Chirag Tailor	7738240256	Maharashtra	West Ra
Mohmad Idris Akbar  Shaikh	9222999710	Maharashtra	North Ra
Ankesh	8898101766	Maharashtra	North Ah
Sagar Bhangare	9260435066	Maharashtra	West Ah

How can we join this tables using joins and then sort according to the Region.

eg.

Name	Mobile	Status	Region	City
Amit Prabhu	9820261173	Maharashtra	West Th	West Thane
Narayan Nihalani	9324764624	Maharashtra	West Mu	West Mumbai
Rameez Shaikh	9930038445	Maharashtra	East Mu	East Mumbai
Deepak Soni	8080106009	Maharashtra	South Mu	South Mumbai

and so on

****  The City name should be sorted such that All west thane should be together, all West Mumbai should be together...