select ... from table1"T11" join table2"T2" on "T11".orign="T2".CityId join table1"T12" on "T12".Finish="T2".CityId 个人感觉SQL99标准更容易理解,SQL92也可以,只不过一个是连接,另一个是过滤
第2个回答 2015-11-04
select * from table1 left join table2 on convert(varchar,table1.A)+convert(varchar,table1.B)=table2.C