Maybe use the LIN. prefix before all WHERE columns, or all over where
applicable.
Like: WHERE LIN.AnoAlbaran=2007 and LIN.SerieAlbaran=0 and LIN.idAlbaran=36

> 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