0
Hello, I need to assemble a query in the database that returns a set of records but as I do not have as much experience in database I would like you to give me a help. I got the tables
tb_departure(id, flag_ativa, flag_cancelado, flag_finalizado, data_hora, time_casa_gols, time_fora_gols, tb_id_cotacao, tb_campeonato_id);
tb_partida_time(tb_partida_id, tb_time_id, order);
tb_time(id, time_name, tb_championships);
tb_quotation(id, casa, empate, fora, gol_meio, mais_2gm, menos_3gm, ambas_marcam, casa_empate, fora_empate, casa_marca, fora_marca, casa_ou_fora, casavence_foramarca, foravence_casamarca, casavence_zero, foravence_zero)
tb_championship(id, camp name, tb_pais_id).
In my app I need to assemble, for each in my bank, an HTML that shows a table with the start times, date/time and quotations. I need to build a table for each championship match that will have all this data. Can anyone help me to do this query?
Wouldn’t it be easier to use a table to store the records and use it as a reference ? Creating a table for each match is really necessary ?
– Mauro Alexandre
I meant that I need to build an HTML table with the records. Like the photo table.
– Guilherme Ramalho
So you want select and table in HTML?
– Sorack
Will be the end result but I need help only with select.
– Guilherme Ramalho