Bill
Try
SELECT SUM(outwt),SUM(inwt) INTO voutwt INDIC vin_1,vinwt INDIC vout_1 +
FROM impraw WHERE trial = '28692' AND plotNum = 309
Buddy
-----Original Message-----
From: Bill Niehaus [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 1:32 PM
To: [EMAIL PROTECTED]
Subject: Select SUM question
I am trying to SELECT multiple SUMS in one statement in Rbase 6.5++ for
WIN
SELECT (SUM(outwt)) INTO voutwt IND vin_1, (SUM(inwt)) INTO vinwt IND
vout_1 +
FROM impraw WHERE trial = '28692' AND plotNum = 309
This works ok if I leave the second SUM out of the command.
Can you string multiple SELECT SUMS together?
Bill
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
