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
