Hello, I need to set up a query in the database that returns a set of records but since I do not have as much experience in the database I would like you to give me some help. It is as follows: I have the tables
tb_partida (id, flag_active, flag_cancelado, flag_finalizado, date_hora, time_casa_gols, time_fora_gols, tb_id_cotacao, tb_campeonato_id );
tb_time_partime ( tb_partida_id, tb_time_id, order );
tb_time ( id, time_name, tb_campeonato_id );
tb_cotacao ( id, home, away, gol_meio, mais_2gm, in>)
tb_campeonato ( id, camp_name, tb_pais_id ).
In my app I need to mount, for each in my bank, an HTML that shows a table with the teams of the match, the date / time and the quotes. I need to build a table for each league match that will have all this data. Can anyone help me with this query?