RE: Help Pub Crawl display

2001-01-25 Thread Scott Gerhardt
What you want to accomplish CAN be done but I'm not sure if it can be done with one SQL statement at all. What you want could be done within code. > Thanks for your reply. Believe I'm thristy two and if I ever get this > thing to work I'm going to pub crawl all the way home. > > What I am tryin

Re: Help Pub Crawl display

2001-01-25 Thread Richard Reina
Thanks for your reply. Believe I'm thristy two and if I ever get this thing to work I'm going to pub crawl all the way home. What I am trying to do is display the beginning and ending points for each pub crawl effedtively leaving out any intermediate stops so that the summary of the pub craw occu

RE: Help Pub Crawl display

2001-01-25 Thread Scott Gerhardt
Your Query is making me thirsty ;-) Unfortunately your tables got garbled so I had to improvise. Next time don't paste the tables beside each other... Also, I'm not sure if I understand your problem or what you are trying to accmplish. Are you trying to de-normalize your data and display the Be