Epic FaiL Index du Forum
Epic FaiL
Forum de la Team [EcFL] sur Call of Duty MW2.
 
Epic FaiL Index du ForumFAQRechercherS’enregistrerConnexion

:: Sorting League tables ::

 
Poster un nouveau sujet   Répondre au sujet    Epic FaiL Index du Forum -> Epic FaiL -> Matchs à venir ! ICI !
Sujet précédent :: Sujet suivant  
Auteur Message
kevinmanuel


Hors ligne

Inscrit le: 20 Mar 2018
Messages: 22
Localisation: adger
Masculin Bélier (21mar-19avr)
Grade: Prestige 5
Niveau: 0
Prénom: kevin

MessagePosté le: Dim 22 Avr - 09:17 (2018)    Sujet du message: Sorting League tables Répondre en citant

Hi,


I manage a database which I created several years ago that handles the matches played among various croquet clubs. For each league all the clubs in that league play one match against the other clubs in the league. A match consists of 12 games and each game consists of up to 13 hoop points.
The final results in the league are sorted by:
No. of Matches won
No. of Games won
No. of Hoop Points won.
I had no problem in producing the league table reports sorted as above. However, twice in the last two years it has happened that two clubs have scored exactly the same no. of matches, in which case an additional rule has been added - in the match that the two clubs played, the club that won is placed ahead of the club that lost (regardless of how many games and hoop points they won). Is there a way of achieving this extra sort using SQL? - currently I manually adjust, but it would be nice if it were automatic.
The tables I have are that are relevant:
Clubs (Fields: ClubID, ClubName, plus other fields not relevant to this problem)
Matches (Fields: MatchID, HomeClubID, AwayClubID plus other fields not relevant to this problem)
GameResults (Fields: GameID,MatchID, GameNo, HomePoints, AwayPoints)
I manipulate the data using SQL queries to give the final table/view for the report, View_RepLeaguesFinal with fields: 
ClubName, TotalMatchWins, GameWins, HoopPoints, GamesPlayed sorted in order of TotalMatchWins, GameWins, HoopPoints
So in summary, when two clubs have the same TotalMatchWins I want to check which club beat the other and re-sort putting the winning club of the pair first.
I hope I have explained this problem clearly enough. Maybe someone has seen this problem before? If I can't do it with a SQL query then I'll have to write a macro to do it - or continue to manually adjust.


Any help will be apprecited.


I didn't find the right solution from the Internet. 


References:
https://forum.openoffice.org/en/forum/viewtopic.php?f=42&t=82064
Video marketing agency


Thank you.
Revenir en haut
Visiter le site web du posteur
Publicité






MessagePosté le: Dim 22 Avr - 09:17 (2018)    Sujet du message: Publicité

PublicitéSupprimer les publicités ?
Revenir en haut
Montrer les messages depuis:   
Poster un nouveau sujet   Répondre au sujet    Epic FaiL Index du Forum -> Epic FaiL -> Matchs à venir ! ICI ! Toutes les heures sont au format GMT + 2 Heures
Page 1 sur 1

 
Sauter vers:  




Index | Panneau d’administration | créer un forum | Forum gratuit d’entraide | Annuaire des forums gratuits | Signaler une violation | Conditions générales d'utilisation
Powered by phpBB © 2001, 2005 phpBB Group
Traduction par : phpBB-fr.com