假设A表名称:City,B表名称:GoToselect a.CityName as '出发地', b.CityName as '目的地', c.LeaveDate as '出发时间'from City as a, City as b, Goto as cwhere c.FromCity = a.CityIDand c.ToCity = b.CityID