-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
---
>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
>ta
D
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 usse
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
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_