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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
