Search results

I have two tables, which both have a field called FixtureID in it. One table is called tbl_fixtures and the other tbl_reports. I want to return a list of FixtureID's that are in tbl_fixtures, that are not in tbl_reports. Simple? Sounds it! I tried to use the Not Exists structure as follows...

I am really struggling with this, but I need to combine these two queries. They count the number of goals scored and conceded in a fixture between two teams to give the games played, games won lost and drawn and Goals for and against and points tally. However, I can only get it to work for the...