SQL help?
| From: | Skip Evans | Date: | Sun, 17 May 2009 18:23:09 +0000 |
| Subject: | SQL help? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-292699@lists.php.net to get a copy of this message | ||
Hey all,
I have a SQL requirement I'm not quite sure how to compose.
I have two tables, shows, and shows_dates. It's a one to many relationship where there is a single entry in shows and multiple entries in shows_dates that list each date and time for a play production for a run of entries in shows, like
I need a query that will read each record in shows, but I only want the first record from shows_dates, the first one sorted by date, so I can display all shows in order of their opening date.
Not sure how to grab just the first record from shows_dates though.
Hint, anyone?
Thanks,
Skip
--
====================================
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison WI 53703
608.250.2720
http://bigskypenguin.com
------------------------------------
Those of you who believe in
telekinesis, raise my hand.
-- Kurt Vonnegut