Posts by Kito-vini • 1 point
3 posts
-
0
votes0
answers23
viewsQ: How to sum the columns without multiplying the sums?
When I run this query it sums the columns several times in the same number of outputs in the table itemsaida. select p.idproduto codigo, p.descricaoproduto nome, sum(e.qtde) entrada, sum(s.qtde)…
-
-1
votes1
answer48
viewsQ: Why can’t I group data into that query?
SELECT e.idproduto codigo, p.descricaoproduto nome, sum(e.qtde) entrada, sum(s.qtde) saida FROM itementrada e INNER JOIN produto p ON e.idproduto = p.idproduto INNER JOIN itemsaida s ON p.idproduto…
-
-2
votes2
answers1111
viewsA: Import Pysimplegui in Visual Code
I recently had this problem using Python 3.9. After a lot of searching and finding nothing, I decided to search my machine for the solution. I have resolved as follows: When running the pip3 install…