Re: SELECT frmo two tables

2002-03-27 Thread Paul DuBois
] >- 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/

Re: SELECT frmo two tables

2002-03-27 Thread Michael Stassen
gt; > > > > E.g., associating by player number: > > > > > > Database.players: > > > player_name, player_number, team, position > > > > > > Database.stats: > > > player_number, penalty, groundballs, shots, faceoffs_won, > > > faceoffs_lost, date &g

Re: SELECT frmo two tables

2002-03-27 Thread Steve Suehring
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: &

Re: SELECT frmo two tables

2002-03-27 Thread Alex Behrens
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

Re: SELECT frmo two tables

2002-03-27 Thread Paul DuBois
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

Re: SELECT frmo two tables

2002-03-27 Thread Mike
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

Re: SELECT frmo two tables

2002-03-27 Thread Alex Behrens
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

Re: SELECT frmo two tables

2002-03-27 Thread mike
t: Wednesday, March 27, 2002 7:00 PM Subject: SELECT frmo two tables > Hey All, > > I am having problems working on a script and need some advise. Here's my > problem. I have two tables with teh following variables: > > rahs table: > name, number, team, position > >

RE: SELECT frmo two tables

2002-03-27 Thread Ron Jamison
To: [EMAIL PROTECTED] Subject: SELECT frmo two tables Hey All, I am having problems working on a script and need some advise. Here's my problem. I have two tables with teh following variables: rahs table: name, number, team, position stats table: name, team, penalty, groundballs, shots, faceoffs

SELECT frmo two tables

2002-03-27 Thread Alex Behrens
Hey All, I am having problems working on a script and need some advise. Here's my problem. I have two tables with teh following variables: rahs table: name, number, team, position stats table: name, team, penalty, groundballs, shots, faceoffs_won, faceoffs_lost, date and I need to make it so u