I have the following query called the lonleyquery, however the query works fine with the sql code as follows, but I want t encoporate the fields that you see in the design of the query, I am no good at coding so could some one please adjust the sql to still give the same result but with the additional fields in that I require.
View copy of lonley query and you will see the additional tables that I need adding they are
League type Match date, match Type Our team Name and opp Team Name.