Posts by Fabio Gomes • 21 points
3 posts
-
1
votes0
answers34
viewsQ: 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,…
-
0
votes0
answers23
viewsQ: 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…
-
0
votes1
answer73
viewsQ: 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…