Subject | Error in calculations SQL |
---|---|
Author | dcanyas2 |
Post date | 2007-01-15T08:32:46Z |
When I make the following one I calculate by means of a sentence SQL:
SELECT sum(coalesce(Precio, 0) * coalesce(Cantidad, 1) *
(100-coalesce(Descuento, 0))/100)*1.16 as TotalAlbaran
FROM LinAlbaranes LIN
WHERE AnoAlbaran=2007 and SerieAlbaran=0 and idAlbaran=36
Leaves an error to Me 'Invalid KeyLinks entry: LIN.ANOALBARAN', I am
using beta 14
SELECT sum(coalesce(Precio, 0) * coalesce(Cantidad, 1) *
(100-coalesce(Descuento, 0))/100)*1.16 as TotalAlbaran
FROM LinAlbaranes LIN
WHERE AnoAlbaran=2007 and SerieAlbaran=0 and idAlbaran=36
Leaves an error to Me 'Invalid KeyLinks entry: LIN.ANOALBARAN', I am
using beta 14