On 8/25/2014 7:52 PM, Errol Emden wrote:
FROM stops astop
JOIN stops bstop ON bstop.name='Craiglockhart' OR bstop.name='Sighthill'

Why are you checking two names against stop B, and none against stop A?

You also need to check that route A and route B actually connect - that the end stop of one is the start stop of the other.

I suggest you draw a picture, then write down all the conditions that need to be true to ensure that all the dots and lines connect to each other the right way.
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to