Marc - Save your select statement in a view with alias names and then unload data from the view as csv or use the gateway export.
Sami ----------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 [EMAIL PROTECTED] http://www.softwaremgmt.com ----- Original Message ----- From: "marc schluter" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 6:08 PM Subject: [RBASE-L] - select question > Hi all > > I can do this in the report writer but I want to be > able to export this data to a WK1 file. > > So, is there a way to do this? > > SELECT IMON(xdate),IYR(xdate),Sum(col1),Sum(col2)... > FROM table > GROUP by IMON(xdate),IYR(xdate) > > I am trying to get something like this > 1 2002 125 $5,000 ... > 2 2002 145 $5,500 ... > > And if possible make another Select statement that > would group by the week. I know I am Dreaming but my > brain just can't seem to work this out. > > Thanks > marc > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Shopping - Send Flowers for Valentine's Day > http://shopping.yahoo.com > > > >
