got stuck with inner join in sql server 2005

Try:

SELECT s.*, 
       c.* 
FROM tblSchedules s
INNER JOIN tbtCity c
ON s.cityID = c.cityID

[edit]
"Markdown" stole the asterisks!
If you still can't see them, between the SELECT and the FROM should be an "s." and a "c." both followed by a "*"
[/edit]


[edit]
It helps if you are specific! :laugh:
You need a JOIN for each column in the schedules you want to replace with the city name:

SELECT s.ScheduleId, s.FlightId, c1.CityName AS [From], c2.CityName AS [To], s.Departure_Time, s.Arrival_Time, s.[Date]
FROM tblSchedules s
INNER JOIN tblCities  c1
ON c1.CityID = s.Source
INNER JOIN tblCities c2
ON c2.CityID = s.Destination

Will give you:

ScheduleId FlightId     From       To Departure_Time Arrival_Time      Date
         4        1   Mysore   Mumbai        5:30 PM     10:20 AM  5/9/2015

A couple of suggestions though: Dump the three columns "Departure_Time", "Arrival_Time", and "Date" and replace them with two DATETIME fields: "DepartAt" and "ArriveAt" - storing dates and times separately means using strings, and that causes all sorts of problems later on. Using DateTime values means you can do math, searching, and sorting on them a lot easier. (And it shows that the aircraft doesn't travel back in time, as it seems from your illustration! :laugh: )

[/edit]