Last post Jan 29, 2019 10:01 AM by wmec
Member
239 Points
1070 Posts
Jan 29, 2019 09:24 AM|Capricon User|LINK
i treid this query
select sum[amount ist] as Amount , id, category from abctable
where category in [ 'a', 'b', 'c' ]
group by id , category
now this an error
invalid column name SUM
what should i do
Contributor
6382 Points
5678 Posts
Jan 29, 2019 10:01 AM|wmec|LINK
Try
select sum([amount ist]) as Amount , id, category from abctable where category in('a', 'b', 'c') group by id , category
Member
239 Points
1070 Posts
invalid column name sum
Jan 29, 2019 09:24 AM|Capricon User|LINK
i treid this query
select sum[amount ist] as Amount , id, category from abctable
where category in [ 'a', 'b', 'c' ]
group by id , category
now this an error
invalid column name SUM
what should i do
Contributor
6382 Points
5678 Posts
Re: invalid column name sum
Jan 29, 2019 10:01 AM|wmec|LINK
Try
select sum([amount ist]) as Amount , id, category from abctable where category in('a', 'b', 'c') group by id , categoryHuaMin Chen