Posts by André Cordeiro • 1 point
1 post
-
0
votes3
answers3385
viewsA: 2 COUNT within a SELECT with LEFT JOIN
I don’t know which database you are using, but follow an example in SQL Server: SELECT A.email, SUM(B.id_envia) AS [Total de envios], SUM(B.id_recebe) AS [Total de recebidos] FROM usuarios AS A…