Posts by Victor Cezario • 36 points
1 post
-
2
votes1
answer317
viewsA: SQL counting data from the second table of INNER JOIN, but shouldn’t?
Try that one: SELECT count(id) as indicados, id_patrocinador from patrocinadores WHERE id_usuario IN (SELECT id_user FROM cotas WHERE status = 1) group by id_patrocinador…