Help to select mount in bank

0

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?

    
asked by anonymous 07.11.2016 / 22:44

0 answers