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
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
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
PUB TABLEEVENT TABLE
|p_id|pub_name |address ||eventid|date
|host_id|
|13 |John Barleycorn's |1800 N. Lincoln ||321|2001-01-27 |
32|
|26 |Harry Carry's |300 N. Dearborn ||198|2001-02-21 |
