Followup your one question at one place only. This question does not mean anything for us.
Looks like you are talking about this thread of yours:
http://www.codeproject.com/answers/68638/About-Sql-Query.aspx[
^]
referring that thread...
ritesh2712 wrote:
hotelTable which contain cityid and related to
Whats the problem?
Select HotelName, cityName
FROM hotelTable
Inner Join CityTable
on HotelTable.CityID=CityTable.CityID
Please pick a good SQL book and read. It would help.