At 18:03 -0700 10/15/02, Jeff Kilbride wrote: >Commas in the FROM clause are the same as INNER JOIN.
Not any more. That was true up until 3.23.17, at which point INNER JOIN was changed to require an ON or USING clause. > 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? --------------------------------------------------------------------- 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
