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 occupies only one row of the display. In
addition, the diaplay needs to pickup various other pieces of data such
as the hosts name and the events date. What seems to be making it
difficult is grabbing only the begining and ending points of the crawl.
I appreciate you help.
Scott Gerhardt wrote:
> 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
> Are you trying to de-normalize your data and display the Beggining and
> Ending Pubs for each stop?
> - Scott
> > I am trying to do a select that would allow me to display the following:
> > ** UPCOMING PUB CRAWLS **
> > Event
> > ID Beginning Ending Date Hosted By
> > 321 Cubby Bear Harry Carry's 01-27-01 Sammy Sosa
> > 198 River Shannon Cubby Bear 02-21-01 unassigned
> > 369 John Barleycorn Wrightwood Tap 02-23-01 Pamela Anderson
> > My select statement below is not cutting it and I beginning to wonder if
> > what I want to do can be done with a select statement or a join. If it
> > can some help me figure out how. If it can' can someone suggest some
> > other way of going about it.
> > SELECT e.eventid, e.date, e.host_id, p.name h.name
> > FROM event e, pub p, host h, stop s
> > WHERE e.eventid=s.event_id
> > AND s.p_id=p.p_id
> > AND e.host_id=h.host_id
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> > To request this thread, e-mail <mysql-thread63111@stripped>
> > To unsubscribe, e-mail
> > <mysql-unsubscribe-scott=gerhardt-it.com@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php