参考:
select sinputdesc,ssignalpoint,b.tstart,b.tend,c.tend from table1 a join table2 b on a.ifpspointnum=b.spoint join table2 c on a.isignalpointnum=c.spoint where b.tend=c.tstart