I have a problem with my query
in MySQL:
SELECT
*
FROM 'campeonatos'
INNER JOIN 'jogos'
ON 'campeonatos'.'camp_id'='jogos'.'campeonato_id'
WHERE 'jogos'.'inicio' > "2017-10-30 00:00:00"
ORDER BY 'campeonatos'.'camp_nome' ASC
The problem that it groups and only returns the first record. I would like it to group for the championship and return something like this:
Campeonato : 888
São Paulo x Flamengo
São Paulo x Flamengo
Campeonato 889
São Paulo x Flamengo
São Paulo x Flamengo