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 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.
>
> Richard
>
> 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
> > accmplish.
> > 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 <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > >
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
