Commas in the FROM clause are the same as INNER JOIN. To make it clearer and easier to understand, I'd write it something like this:
SELECT psh.StatID, pt1.TeamName AS Home, pt2.TeamName AS Visitor, psh.GameDate FROM PH_TEAMS pt1, PH_TEAMS pt2, PH_SCORE_HEADER psh WHERE psh.Home = pt1.TeamID AND psh.Visitor = pt2.TeamID; --jeff ----- Original Message ----- From: "Michael J. Mitchell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 12:24 PM Subject: Query using the same table twice > > I am trying to make a query that usses the same table twice. I have a table > of scores and a table of teams and the scores table has both the visitors > and home team in it as an ID that is in the teams table. I can't get my > MySQL statement to work, it does not like the parentheses. > > SELECT PH_SCORE_HEADER.StatID, PH_TEAMS.TeamName AS Home, > PH_TEAMS_1.TeamName AS Visitor, PH_SCORE_HEADER.GameDate > > FROM PH_TEAMS AS PH_TEAMS_1 INNER JOIN (PH_TEAMS INNER JOIN PH_SCORE_HEADER > ON PH_TEAMS.TeamID = PH_SCORE_HEADER.Home) ON PH_TEAMS_1.TeamID = > PH_SCORE_HEADER.Visitor; > > I think the problem is with the Parenthesies, but I don't know how to > re-write the SQL. > > Any suggestions? > > > _________________________________________________________________ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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