Not updatble query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all
I have the fowling query statement, returning a non updatable query.
I can not understand is it not updatable.

SELECT FacturaVenda.NIF, FacturaVenda.DocID AS Factura,
(nz([quantidade]*[preço]*(1+[iva]),0)-(nz([valor],0))) AS Divida,
Recebimentos.Valor, Recebimentos.Recibo
FROM (FacturaVenda LEFT JOIN Recebimentos ON FacturaVenda.DocID =
Recebimentos.Factura) INNER JOIN VendaArtigos ON FacturaVenda.DocID =
VendaArtigos.DocID
WHERE (((Left([FacturaVenda].[DocID],2))="ft")) OR
(((Left([FacturaVenda].[DocID],1))="N"));

I most appreciate if some one could explain what is the problem whit it.
 
It's the LEFT JOIN. It may be updateable if it's an inner join with one of
the fields being the table's primary key.

Even if it was just a single table, you wouldn't be able to update the
Divida field as it's a calculation.
 
Back
Top