SportsDB Home
Documentation
Specification
Samples
Query Library
SportsCaster Web Service
Hosted on SourceForge
and licensed under
Creative Commons GNU GPL.
Query Library
| Alan Karben submitted this query on: February 07, 2008 1:16am EST | |
| TITLE | Get all season info on one event |
|---|---|
| SPORTS | ALL SPORTS |
| QUERY | SELECT * FROM events, events_sub_seasons, sub_seasons, seasons WHERE events.event_key = 'l.mlb.com-2007-e.18640' AND events_sub_seasons.event_id = events.id AND events_sub_seasons.sub_season_id = sub_seasons.id AND sub_seasons.season_id = seasons.id |
| DESCRIPTION | shows season info |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |