List:General Discussion« Previous MessageNext Message »
From:Richard Reina Date:January 25 2001 2:34am
Subject:Re: Help Pub Crawl display
View as plain text  
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 <mysql-thread63111@stripped>
> > To unsubscribe, e-mail
> > <mysql-unsubscribe-scott=gerhardt-it.com@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
Thread
Help Pub Crawl displayRichard Reina26 Jan
  • RE: Help Pub Crawl displayScott Gerhardt26 Jan
    • Re: Help Pub Crawl displayRichard Reina26 Jan
      • RE: Help Pub Crawl displayScott Gerhardt26 Jan
  • Re: Help Pub Crawl displayHarald Fuchs28 Jan