Hi

I would like to know if there is a way to do a subquery with SQLServerCE (the one for PocketPC)

SELECT IDField, Sum(Value)
FROM
(
   SELECT IDField, Value FROM Table1
   UNION ALL
   SELECT IDField, Value FROM Table2
) t
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 ?

thanks


Jeff
http://www.ikma.ca

Hi Jeff,
Yes you can.

SELECT * FROM table WHERE field IN (SELECT field FROM table WHERE field condition)
Please post if you need more help regarding this.


nalaka hewage