Hopefully a simple one, thouhg I am too knackered to work it out (lazy oik)
I have a MATCH table which has a home team and an away team
Both the Home and Away team pull off the team from the same table of teams
There is more information but it is not important.
I know how to code a simple SELECT staement using a JOIN to pull of the name of ONE of the teams, but have never done it for TWO.. any help appreicated.