Group by only 1 result

0

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
    
asked by anonymous 30.10.2017 / 15:35

0 answers