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