SELECT caseid, recid, trandate, description, amount, SUM(amount) AS billtotal
FROM billtran GROUP BY caseid
The above SQL executes and gives me what I want under PHP/MySQL, but it won't even execute under VS2010 Express. When I put the above SQL code in the Dataset Designer Query Builder, I get an error: "In aggregate and grouping expressions, the SELECT
clause can contain only aggregate and grouping expressions. [ Select clause = ,recid ]"
I don't understand what the problem is. What is the thing I must know about SQL that is different under Microsoft?
View Complete Post