Robert Henkel accidentally sent a reply to me instead of to you or to
the mailing list. In his reply he states that he tried your SELECT
statement and it worked fine. If so, then the problem is in the
normalized version, and is probably a simple error similar to the one
I pointed out. Post you
The errors are in the example below not in the code that i'm working
with. the group by would be school_name or school_id otherwise the
query would error and I wouldn't be experiencing the oddities that I am.
What it seems to be is that if I want to preform math on 2 sum
functions, (+-*/) it
>I'm gaving a problem with adding several sums together when using a
>group by clause. The table I have looks like this:
>
>school_id int
>school_name varchar
>sport varchar
>cost_a float(9,2)
>cost_b float(9,2)
>cost_c float(9,2)
>
>The real table is normalized, fi
I'm gaving a problem with adding several sums together when using a
group by clause. The table I have looks like this:
school_id int
school_name
varchar
sport
varchar
cost_a
float(9,2)
cost_b
float(9,2)
cost_c
float(9,2)
The real table is normalized,
