Hello everyone, a newbie here.
I'm working on a football(soccer) database, and I need a query(or queries) that would display match results in this form: date, team1, results, team 2 example: (24/1/2017, CLUB DE FOOTBALL SECRETARIAT, 4-0, FOOTBALL CLUB DE TETOUAN)
Tables: it's all in french, where equipe=team, But= Goals, Joueur=Player, Arbitre= referee, faute=freekicks..
Match:
Goals:
Teams:
your help would be very much appreciated!