SELECT * FROM through TT,train WHERE TT.TrainNum = train.TrainNum AND EXISTS (SELECT * FROM through TS,station SS WHERE TS.TrainNum = TT.TrainNum AND TS.Station = SS.Name AND SS.City = 北京
在数据库总是提示#1064 - You have an error in your SQL syntax; check the manual that corresponds 的错误提示
在数据库总是提示#1064 - You have an error in your SQL syntax; check the manual that corresponds 的错误提示
SELECT * FROM through TT,train WHERE TT.TrainNum = train.TrainNum AND
EXISTS (SELECT * FROM through TS,station SS WHERE TS.TrainNum = TT.TrainNum AND TS.Station = SS.Name AND SS.City = '北京')
join train on tt.trainNum=train.TrainNum
join station ss on tt.station=ss.name and ss.city='北京'