Problems with a QUERY using C/ODBC into Navision 2.60

esmetaman

Hi, I have a problem with SQL

I want to Sum of the multiply of 2 Columns

SELECT

"P"."Cód_ familia" AS "IDFAMILIA",
SUM("MP"."Cantidad facturada" * "MP"."Precio unitario" ) AS VENTAS


FROM
"Mov_ producto" "MP",
"Producto" "P"

WHERE
"P"."Nº" = "MP"."Nº producto"
AND
"MP"."Tipo movimiento" = 1
AND
"MP"."Fecha registro">={d '2005-09-01'}
AND
"MP"."Fecha registro"<={d '2005-09-30'}
AND
"P"."Cód_ familia" LIKE 'AG%'

ORDER BY
"P"."Cód_ familia" ASC

Can you help me