select g.gameid, g.homeid, h.name, g.awayid, a.name, g.datetime
from Games g, Teams h, Teams a
where g.datetime > @min_dt
and g.datetime < @max_dt
and h.teamid = g.homeid
and a.teamid = g.awayid
On Mon, 30 Dec 2002 11:29:45 -0600, <[EMAIL PROTECTED]> wrote:
Hello,
This is my first post to the list, so if I am asking in the wrong place,
I apologize.
I've got some trouble putting together a query with the following tables
Games: Teams:
gameid teamid
homeid name
awayid
datetime
i want to get all games within a certain timeframe, but also retrieve the
team names for both the homeid and awayid (these are both links to the
teams.teamid field).
Not sure how to get two results from the same table in one query.
Can anybody point me in the right direction.
thanks
gf
---------------------------------------------------------------------
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 <mysql-unsubscribe-
[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