Subject | Re: Error in calculations SQL |
---|---|
Author | dcanyas2 |
Post date | 2007-01-17T07:40:29Z |
When I execute select:
SELECT sum(coalesce(Precio, 0) * coalesce(Cantidad, 1) *
(100-coalesce(Descuento, 0))/100)*1.16 as TotalAlbaran
FROM LinAlbaranes
WHERE AnoAlbaran=2007 and SerieAlbaran=0 and idAlbaran=36
it gives back the error to me "Invalid KeyLinks entry:
LINALBARANES.ANOALBARAN"
SELECT sum(coalesce(Precio, 0) * coalesce(Cantidad, 1) *
(100-coalesce(Descuento, 0))/100)*1.16 as TotalAlbaran
FROM LinAlbaranes
WHERE AnoAlbaran=2007 and SerieAlbaran=0 and idAlbaran=36
it gives back the error to me "Invalid KeyLinks entry:
LINALBARANES.ANOALBARAN"