Bill: Try it this way:
SELECT SUM(outwt),SUM(inwt) INTO voutwt IND vout_1,vinwt IND vin_1 + FROM impraw WHERE trial = '28692' AND plotNum = 309 -----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/
