title: Sql select statement with two foreign key taken from the same table
body: <pre><code>create table A ( 
      cityID int, 
      cityname nvarchar(30), 
      primary key (cityID)
  )
  
  create table b (
      travelID int, 
      fromcityID int, 
      tocityID int, 
      primary key (travelID),
      foreign key (fromcityID) references A (cityID),
      foreign key (tocityID) references A (cityID)
  )
  
  insert into A values(1,'amman');
  insert into A values(2,'Irbid');
  
  insert into B values(1,1,1)
  insert into B values(2,1,2)
  insert into B values(3,2,1)
  insert into B values(4,2,2)
  
  
  
  select travelID, a.cityname,a.cityname  from A, b where ????
  </code></pre>
  
  <p>What should I write in the select statement to view the city name instead of its id? </p>