-jeff
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Jeff Kilbride" <[EMAIL PROTECTED]>; "Michael J. Mitchell"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 6:46 PM
Subject: Re: Query u
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
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
No time to figure out what you are doing, but I think
you will find your answer here - if not send the table
structure for the table you store the team id of the
home and visitor in:
http://www.wdvl.com/Authoring/DB/SQL/Joins/
olinux
--- "Michael J. Mitchell" <[EMAIL PROTECTED]>
wrote:
>
> I a
