Data in the design of repeated problems-CodePudding

Trains and stations to repeat how should solve
In addition to poor shimen north to which car is only 267 should be how to operate

CodePudding user response:

Trains and stations repetitive refers to trains and stations at the same time, one or both of these can be repeated,

 
SELECT A. * 
FROM the TABLE A 
JOIN TABLE B ON A.T RAINNO=B.T RAINNO 
WHERE A.S TATION='cross north AND B.S TATION=' which is' 
AND A.A RRIVETIME

CodePudding user response:

There are a lot more than 50 stations in the actual development and more than 40 trains could you tell me how to design my demand is to be able to tables should be trains through the station and find out the time