Hi,
I am recording results of matches between various teams in various tournaments.
My columns for the score table are HomeTeam, AwayTeam, Tournament, HomePoints, AwayPoints.
e.g.
HomeTeam|AwayTeam|Tournament|PointsHome|PointsAway
----------------------------------------------------------
A...
Hi - I'm struggling with a query, which is as follows.
(I have changed the context slightly for simplicity)
I have 4 tables: users, scores, trials, tests
Each pair of users takes a series of upto 4 tests in 1 trial, getting a score for each test.
There are a different numbers of trials for each...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.