Hi, i try to run

Select F.Id,
(select Sum(RIWTE_FattRec.Prezzo * RIWTE_FattRec.Quantita)
FROM RIWTE_FattRec WHERE RIWTE_FattRec.IdFattura = F.Id ) as totale
from RIWTE_Fatture F


I receive this error
************************************************** **
ODBC Error: SQLSTATE = 37000, Native error code = 0
Syntax Error: Select F.Id,
(select<< ??? >> Sum(RIWTE_FattRec.Prezzo * RIWTE_FattRec.Quantita)
FROM RIWTE_FattRec WHERE RIWTE_FattRec.IdFattura = F.Id ) as totale
from RIWTE_Fatture F

Releases:
Pervasive Sql 8.50
Pervasive Control Center 8.50.189.000

Thanks to all.

Alessandro Zambonin

Pervasive.SQL V8 does not support sub select statements.

After looking closer at your statement I don't think you need a sub
select to do this.

Try this instead:

Select F.Id, Sum(RIWTE_FattRec.Prezzo * RIWTE_FattRec.Quantita) as
totale
from RIWTE_Fatture F inner join RIWTE_FattRec on
RIWTE_FattRec.IdFattura = F.Id
group by F.Id

Hope this helps.

Eric Purdin