I would like to know if there is a way to do a subquery with SQLServerCE (the one for PocketPC)
SELECT IDField, Sum(Value)
SELECT IDField, Value FROM Table1
SELECT IDField, Value FROM Table2
GROUP BY IDField
It gave me a Parsing Error on the second SELECT... but this query work on SQLServer.
Does anybody have a hint about how to be able to do this query ?