]
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Alex Behrens" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Wednesday, March 27, 2002 9:45 PM
>Subject: Re: SELECT frmo two tables
>
>
>> At 20:14 -0600 3/
-
> > -Alex "Big Al" Behrens
> > E-mail: [EMAIL PROTECTED]
> > Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
> > Phone: 651-482-8779
> > Cell: 651-329-4187
> > Fax: 651-482-1391
> > ICQ: 3969599
> > Owner of the 3D-Unlimited Networ
ne: 651-482-8779
> Cell: 651-329-4187
> Fax: 651-482-1391
> ICQ: 3969599
> Owner of the 3D-Unlimited Network:
> http://www.3d-unlimited.com
> Send News:
> [EMAIL PROTECTED]
> - Original Message -
> From: "Paul DuBois" <[EMAIL PROTECTED]>
> To: &
9
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Alex Behrens" <[EMAIL PROTECTED]>; <[EMAIL PR
At 20:14 -0600 3/27/02, Alex Behrens wrote:
>hey guys,
>
>this mysql line doesn't seem to work:
>
>SELECT SUM(s.groundballs) AS grounders FROM stats s LEFT JOIN rahs r ON
>s.name = r.name WHERE (s.position = '$position')
>
>why not? is there somethign wrong with my syntax? it says this error:
>"Su
I would check the value of $position to make sure it's what you want.
Mike
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "Ron Jamison" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 9:14 PM
Subje
tp://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: "Ron Jamison" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 6:21 PM
Subject: RE: SELECT frmo two tables
> If you need to do a join:
> http://www.my
Look in the mysql manual on joins.
http://www.mysql.com/doc/J/O/JOIN.html
There is also some articles on this subject at
http://www.onlamp.com/onlamp/general/mysql.csp
Mike
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 20
If you need to do a join:
http://www.mysql.com/doc/J/O/JOIN.html
However I don't see much logic in what you're doing. Stats should not
include information that exists in another table, such as name and team.
You need to decide what information will be unique (such as player
number) or come up
