select B.出发城市, B.到达城市
from A
inner join B on B.出发城市 = A.城市
order by A.城市, B.时间

------解决方案--------------------

SQL code


select A.城市,B.出发城市 ,B.时间  from  B 
 left join A on  A.城市=B.出发城市
 group by A.城市,B.出发城市 ,B.时间