Posts by demolion • 31 points

• 1

  votes

  2

  answers

  309

  views

  Q: SQL update query syntax error

  When I run the following update query there is a syntax error before or inside from: UPDATE Artigos SET totale = entradas.sent FROM Artigos INNER JOIN (SELECT cod_artigo, Sum([quantidade_ent]) AS…

  sql query sql-update

  asked 8 years, 4 months ago demolion 31

• 2

  votes

  1

  answer

  198

  views

  Q: access - subtraction in query duplicates values

  I coded the following queries: Somantradastotal: SELECT artigos.Nome, Sum(Entradas.quantidade_ent) AS [Total Entradas] FROM artigos INNER JOIN Entradas ON artigos.Cod_artigo = Entradas.Cod_artigo…

  query ms-access

  asked 8 years, 4 months ago demolion 31