Igor, thanks for a meaningful response. I am a neophyte at SQL, and learning it on my own. The graphical approach to a solution is another methodology I will be adding to my arsenal.
The reason why I was checking both names against stop B is that my intent was to find the other route stops that connected to these stops. I am now aware that these connections are not possible. Errol Emden > To: sqlite-users@sqlite.org > From: i...@tandetnik.org > Date: Mon, 25 Aug 2014 20:05:40 -0400 > Subject: Re: [sqlite] Edinburgh Buses > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users