Hi,

i've write a query:

SELECT     id, Surname, Name
FROM         Statistic AS anag
WHERE     ((SELECT     SUM(Price) AS SumPrez
                        FROM         Purchasing AS Rate
                        WHERE     (Balance = 0) AND (idanagrafica =
anag.id)) -
                         (SELECT     SUM(Installment) AS SumRate
                           FROM          Collections AS Incas
                           WHERE      (Balance = 0) AND (idanagrafica =
anag.id)) < 100)

No have problem with SQL 2005 but if i try to execute on mobile device with
SQL Ce 3.1 (Compact Edition) i've error

Can help me?

Thanks
Raffaele