>Selecting specific columns from a single
>table and doing calculations on that data.
>
>select stno,mo,
>(sales+mreturns) as SALES,
>(cost+costreturns) AS COST
>from linmonsales
>where yr=2005
>and mo in ('11','12')
>and lincode='HPS'
>
>Numbers are stores as double precision.
>
>Any ideas?
As for the second part of your question, I'm not sure I understand what it is your asking?
Could you give a little more information?
Ryan.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
Marathon v3.0.0.50
I have been gettingthis error when tryin gto export table data.
I am not the only one having this problem in my work group.
Selecting specific columns from a single table and doing calculations on that data.
select stno,mo,
(sales+mreturns) as SALES,
(cost+costreturns) AS COST
from linmonsales
where yr=2005
and mo in ('11','12')
and lincode='HPS'
Numbers are stores as double precision.
Any ideas?
>Marathon v3.0.0.50
>
>I have been gettingthis error when tryin
>gto export table data.
If you look in the reported bugs list, there is a listed bug stating that you can't export table data at this time. It is a known issue.
When I get more time I'll have a look at it.
If you really need to export data, run a select against the table in question and export the data from the query results. That feature does work.
Sorry about that.
Ryan.
>Selecting specific columns from a single
>table and doing calculations on that data.
>
>select stno,mo,
>(sales+mreturns) as SALES,
>(cost+costreturns) AS COST
>from linmonsales
>where yr=2005
>and mo in ('11','12')
>and lincode='HPS'
>
>Numbers are stores as double precision.
>
>Any ideas?
As for the second part of your question, I'm not sure I understand what it is your asking?
Could you give a little more information?
Ryan.