Recent content by barry_kellett99

Erm, After posting this i can see straight away what is wrong. I had the two queries back to front :( SELECT Rep.FixtureID FROM tbl_Reports AS Rep WHERE (Exists (SELECT fix.FixtureID FROM tbl_Fixtures AS fix)=true); Works Oh well!

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...

Thanks Dennisk - I've been trying that, but it gives me a row with the teams home results and then below that a row with the same teams away results. I need to combine them into one single row with the sum of the home and away records:(

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...