SportsDB Home

Documentation

Specification

Samples

Query Library

SportsCaster Web Service

Hosted on SourceForge
and licensed under
Creative Commons GNU GPL.

SourceForge.net Logo

CC-GNU GPL

Query Library

Alan Karben submitted this query on: March 03, 2008 1:09pm EST
TITLE Get all teams and final scores for a game
SPORTS ALL SPORTS
QUERY SELECT 
     * 
FROM 
     events, 
     participants_events 
WHERE 
         events.event_key = 'l.nfl.com-2007-e.2153' 
     AND participants_events.event_id = events.id;
DESCRIPTION gets scores
DBs TESTED MySQL
ADDITIONAL NOTES
Comments
on July 07, 2008 3:28am EDT manish wrote:
Metadata: DB Tested: MySQL
Query:
n/a

"yhfh"