Bill N., Yes you can, but the syntax requires the list of columns select, followed by a single INTO clause:
SELECT SUM (outwt), SUM (inwt) + INTO vOutwt IND vin_1, vInWt INT vout_2 + FROM impraw + WHERE trial = '28692' and plutnum = 309 Bill D. On Fri, 27 Sep 2002 12:32:27 -0500, Bill Niehaus wrote: >SELECT (SUM(outwt)) INTO voutwt IND vin_1, (SUM(inwt)) INTO vinwt IND >vout_1 + > FROM impraw WHERE trial = '28692' AND plotNum = 309 ================================================ 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/
