select * from (select * from stationInfo where lineName="31" and lineType="31") as A full join (select * from tempstationID) as B on A.stationName=B.stationName
select * from (select * from stationInfo where lineName="31" and lineType="31") A full join (select * from tempstationID)B on A.stationName=B.stationName
