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: [email protected]
> From: [email protected]
> 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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
