Posts by Fabio Gomes • 21 points

• 1

  votes

  0

  answers

  34

  views

  Q: Doubt with JOINS and GROUP BY in an SQL (Access) query

  Thanks for your help. I am not very advanced in SQL and I am facing a difficulty here, is the following: SELECT tbl_afs_pregao.numaf, tbl_items_pregao.nomeitem, Sum(tbl_items_af.qtd) AS SomaDeQtd,…

  sql query join ms-access inner-join

  asked 3 years, 4 months ago Fabio Gomes 21

• 0

  votes

  0

  answers

  23

  views

  Q: Bring only one record in a left Join even if there are more records in the relationship

  Hello, how are you? This is my query: SELECT cf.id_clifor, cf.nome, lv.localvenda, ed.cidade, ctt.telefone, cf.descontoglobal, lv.id_localvenda FROM ((tbl_clientes_fornecedores AS cf INNER JOIN…

  sql ms-access

  asked 3 years, 5 months ago Fabio Gomes 21

• 0

  votes

  1

  answer

  73

  views

  Q: Doubt with LEFT or INNER JOIN and WHERE SQL Access

  all right? So, I have this query here in Access: SELECT tbl_produtos.NomeProduto, tbl_produtos.PrecoVenda, tbl_precos_especiais.PrecoVenda FROM tbl_produtos LEFT JOIN tbl_precos_especiais ON…

  sql query join ms-access where

  asked 3 years, 7 months ago Fabio Gomes 21