crax15 Posted February 10, 2014 at 11:49 PM Report #544769 Posted February 10, 2014 at 11:49 PM (edited) Boa Noite, gostava de saber se é possivel fazer uma pesquisa por um campo por exemplo o Nome e depois somar o valor de registos que esse nome tem na base de dados. Obrigado Edited February 15, 2014 at 10:30 PM by crax15 Pedro'O
crax15 Posted February 15, 2014 at 10:30 PM Author Report #545430 Posted February 15, 2014 at 10:30 PM Ja descobri... desculpem, fica aqui a resolução SELECT Utilizadores.Nome, SUM(Fundos.Valor) AS Expr1 FROM (Fundos INNER JOIN Utilizadores ON Fundos.Cod_utilizador = Utilizadores.Cod_utilizador) GROUP BY Utilizadores.Nome Pedro'O
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now