RE: URGENT: SUM() QUESTION

2000-09-14 Thread Venu Pillai
- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 10:50 AM To: [EMAIL PROTECTED] Subject: Re: URGENT: SUM() QUESTION select sum(pic + sic + student) as grandtotal from aeps.dbo.flighttimes where membernumber=117 When i run this query in CF in SQL i get

RE: URGENT: SUM() QUESTION

2000-09-11 Thread Justin Kidman
ginal Message - From: "Justin Kidman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 11, 2000 12:19 PM Subject: RE: URGENT: SUM() QUESTION > Hmm, let me get this right, you are just trying to add a column for every > row adding those other 3 colu

RE: URGENT: SUM() QUESTION

2000-09-11 Thread Justin Kidman
9:14 AM To: [EMAIL PROTECTED] Subject: Re: URGENT: SUM() QUESTION What is the proper syntax for a join to make sure i do them right? but even w/o a join its messing up Bill Wheatley Senior Developer AEPS INC http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 - Ori

Re: URGENT: SUM() QUESTION

2000-09-11 Thread William J Wheatley
ROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 11, 2000 12:04 PM Subject: RE: URGENT: SUM() QUESTION > This is not how Sybase SQL is supposed to work! > > Unless there are some other parts of your query > causing it to do a Cartesian product (ie you're > refere

RE: URGENT: SUM() QUESTION

2000-09-11 Thread DeVoil, Nick
time... There's something strange going on here! Nick -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 5:02 PM To: [EMAIL PROTECTED] Subject: Re: URGENT: SUM() QUESTION linux, sybase Bill Wheatley Senior Developer AEP

Re: URGENT: SUM() QUESTION

2000-09-11 Thread William J Wheatley
linux, sybase Bill Wheatley Senior Developer AEPS INC http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 - Original Message - From: "DeVoil, Nick" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 11, 2000 11:52 AM Su

RE: URGENT: SUM() QUESTION

2000-09-11 Thread DeVoil, Nick
Bill > select sum(pic + sic + student) as grandtotal > from aeps.dbo.flighttimes > where membernumber=117 > > When i run this query in CF in SQL i get the column GRANDTOTAL () with the > correct Values of the where but i get every row in the database > so is there an alternate method of doin

Re: URGENT: SUM() QUESTION

2000-09-11 Thread William J Wheatley
he numbers in three of > the columns, then to add together all these numbers and pass > back the result as "grandtotal". > > Is that what you want? > > Nick > > -Original Message- > From: William J Wheatley [mailto:[EMAIL PROTECTED]] > Sent: Monday,

RE: URGENT: SUM() QUESTION

2000-09-11 Thread DeVoil, Nick
all these numbers and pass back the result as "grandtotal". Is that what you want? Nick -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 4:30 PM To: [EMAIL PROTECTED] Subject: Re: URGENT: SUM() QUESTION well I have tested

Re: URGENT: SUM() QUESTION

2000-09-11 Thread William J Wheatley
? Bill Wheatley Senior Developer AEPS INC http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 - Original Message - From: "G" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 11, 2000 9:54 AM Subject: Re: URGENT: SUM() QUESTIO

Re: URGENT: SUM() QUESTION

2000-09-11 Thread G
The SUM function really has nothing to do with how many records your bringing back. Be careful with the "or" clause, this query is going to bring back EVERY combination of the "membernumber/description" values listed below. - Original Message - From: William J Wheatley <[EMAIL PROTECTED